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))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Christina" wrote:

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?