YEAR Function

How to Create Bubble Chart for Categorical Data in Excel (6 Steps)

The article will show you how to create an Excel Bubble Chart for categorical data. Bubble Charts are useful when you work with more than two ...

How to Add and Subtract Dates in Excel (6 Suitable Ways)

While continuing to work with a dataset, sometimes users need to know how to add or subtract dates in Excel. You can simply Add and Subtract Dates in ...

Excel COUNTIF Function with Multiple Criteria & Date Range

If you are looking for ways to use the COUNTIF function with multiple criteria date range in Excel, then this article will be helpful for you. ...

How to Create a Bullet Journal in Excel (with Detailed Steps)

This article illustrates how to create a bullet journal in excel. A bullet journal is a system of organizing to-do lists, daily tasks, monthly goals, ...

Excel Chart by Month and Year (2 Suitable Examples)

Excel charts are excellent tools to visualize and analyze data quickly. Regarding this, it is a very frequent practice to plot a chart by month and ...

Student Loan Payoff Calculator with Amortization Table in Excel

Most of the students had to deal with the loan. The complex calculation of loan Repayment amount and how long it will take is difficult for anybody. ...

How to Calculate Sales Growth over 3 Years in Excel (2 Methods)

Measuring sales growth is one of the key points to measuring the overall company growth. Because more sales mean more potential for higher profit. ...

How to Use Excel Pivot Table to Group Dates by Month and Year

If you want to create Excel Pivot Table Group Dates by Month and Year, this article is for you. Here, we will walk you through 4 simple and easy ...

How to Filter Dates by Month and Year in Excel (4 Easy Methods)

In this article, you will find some easy methods to filter dates by month and year in Excel. It is very common to filter dates by month or year as ...

How to Calculate Age from Birthday in Excel (8 Easy Methods)

The article demonstrates some amazing methods to calculate age from a birthday in Excel. You'll learn a few formulas for calculating age as a number ...

How to Calculate Age in Excel in Years and Months (5 Easy Ways)

Looking for ways to know how to calculate age in Excel in years and months? Then, this is the right place for you. Sometimes, calculate age from a ...

How to Calculate Retirement Age in Excel (4 Quick Methods)

In many offices around the world, calculating retirement age and retirement date is necessary. Luckily, you can accomplish such types of tasks in ...

Difference Between Two Dates in Months in Excel (4 Suitable Examples)

Sometimes you may need to know how many months have passed between two dates. There are multiple ways to find the difference between two dates in ...

Split Date and Time Column in Excel (7 Easy Methods)

If you have a date and time in the same cell and need to separate them into two different columns, you are in right place! In this article, I will ...

How to Calculate Difference Between Two Dates in Days in Excel

We’ll show you 7 quick methods of how to calculate the difference between two dates in days in Excel. To demonstrate our methods, we’ve picked a ...

ExcelDemy
Logo