How to count years between two dates in excel (Updated 2022)

how to count years between two dates in excel

All parts of life rotate around time. All day-to-day exercises we do in our life likewise depend and spin on schedule. We as a whole need to monitor time since it is what is happening. Time is estimated or represented in a flash, minutes, hours, days, weeks, months, and years. 

How to count years or months between two dates?

To work out a long time between years is the overall demonstration of getting the number or the worth in years between two given dates. We can do that just by getting the distinction between the dates or even by the manual counting of the number of months included and afterward making an interpretation of the months to years.

In dominate sheets, we likewise work out the years that are there in two dates or even three dates. In contrast to manual counting, dominate has these implicit equations that assist in the computing of the years.

We have a portion of the means to follow to arrive at a worth of the years between the given dates. These means will incorporate the accompanying and are made sense of beneath along with the models.

Accepting you have the informational collection currently in the current sheets you don’t need to re-try the initial step once more. For the people who are doing it interestingly, open the dominate from your PC, make a new Excel sheet, and prepare two date columns.

Excel Sheets

To get the years between the dates on the above dominate sheets, we will utilize the capacity YEARFRAC. This is the capacity that computes the years between dates. One thing about the YEARFRAC work is that it can ascertain even in decimal, for example, it can show 1.5 years to mean one and a half years.

On the segment with the header, years are the place where we hope to record our outcomes. Enter the accompanying recipe in the equation bar =YEARFRAC (A2, B2) to compute the years between the dates in cell A2 and cell B2.

Years Between Dates in Excel

Use the same formula for the rest of the cells or hold and drag the cursor to automatically calculate the rest of the years.

Step-by-step instructions for finding the difference during the year between the two dates

The above formula calculates years as decimal places if they are not filled. But sometimes you probably just try to count the years. In this case we use the DATEDIF function (start date, end date, “y”)

For example, we will use the same data as above:

Type =DATEDIF(A2, B2,”y”) on the cell that you want to display the results and press Enter. 

DATEDIF Function in Excel

How to calculate the difference in months

To calculate the difference between two days in a month, use the =DATEDIF(start_date, end_date, “m”) function.

M in this position represents a month.

For Example :

Type =DATEDIF(A2, B2,”m”) on the cell that you want to display the results and press Enter

DATEDIF Function in Excel

So friends, in today’s article we learned how to calculate years, months between 2 specified dates with a very easy and small excel function. Hope you will find this article very useful. If so then please don’t forget to share it with your friends and colleagues.

Also, don’t forget to comment below. Your comments inspire me to write such useful articles and various excel related functions. 

Also Read: The Ultimate Guide To Google Sheets 2022


Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.

This Post Has One Comment

  1. Naresh

    Nice explained, and very informative post

Leave a Reply