Can you calculate the number of years between two dates in Excel 0

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

Can you calculate the number of years between two dates in Excel 2003?

Ie. What is the total number of years between 9/21/1992 and 1/10/09?
 
I assume you want full calendar years:

A1 = start date
B1 = end date

=DATEDIF(A1,B1,"y")
 
Hi,

You can also use

=YEARFRAC(A1,A2)

Where A1 is a start date and A2 is the end date. Note this will return
something like 10.234 so if you don't want/need the fractional part you can
modify this to read

=TRUNC(YEARFRAC(D9,D10))
 
Back
Top