Calculate Number of Years and Months Between Dates in Excel?

Spread the love

In this post you will learn how to calculate the number of years and months between dates in Excel.

Calculating number of years and months between dates –

In some cases, you’ll be asked to express the difference between two dates in years and
months. In these cases, you can create a text string using two DATEDIF functions.

Cell C4 shown in Figure below contains the following formula:

=DATEDIF(A4,B4,"Y") & " Years, " & DATEDIF(A4,B4,"YM") & " Months"

We accomplish this task by using two DATEDIF functions joined in a text string with the
ampersand (&) operator.

The first DATEDIF function calculates the number of years between the start and end dates
by passing the year time unit (Y):


The second DATEDIF function uses the YM time unit to calculate the number of months
ignoring the year portion of the date:


We join these two functions with some text of our own to let the users know which number
represents years and which represents months:

=DATEDIF(A4,B4,"Y") & " Years, " & DATEDIF(A4,B4,"YM") & " Months"

Rating: 1 out of 5.

Leave a Reply