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

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.

Table of Contents

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.

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.

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.

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

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