Calculate years between dates

Related Functions

Sponsored Link

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: