Calculate years between dates

An excel formula to calculate years between dates

Related Functions

Sponsored Link

 Calculate years between dates
=YEARFRAC(start_date,end_date)

If you want to calculated the number of years between two dates, you can use the YEARFRAC function, which will return a decimal number representing the fraction of a year between two dates. Here are a few examples of the results that YEARFRAC calculates:

Start date End date YEARFRAC result
1/1/2015 1/1/2016 1
3/15/1970 9/15/1976 6.5
1/1/2000 7/15/2000 .5389
6/1/2000 6/25/1999 .9333

Once you have the decimal value, you can round the number if you like. For example, you could round to the nearest whole number:

 
=ROUND(YEARFRAC(A1,B1),0)

You might also want to keep only the integer portion of the result with no fractional value, so that you are only counting whole years. In that case, you can just wrap YEARFRAC in the INT function:

 
=INT(YEARFRAC(A1,B1))

Sponsored Link

0 votes. 0 / 5