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

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?

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

=DATEDIF(StartDate,EndDate,"y")

See http://www.cpearson.com/Excel/datedif.aspx for details about
DATEDIF.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 3 Dec 2008 14:48:12 -0800, 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?

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

I assume you want full calendar years:

A1 = start date
B1 = end date

=DATEDIF(A1,B1,"y")

--
Biff
Microsoft Excel MVP


"Christina" wrote in message
...
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?

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

Hi,

As a best practise, please ensure that the year is always 4 digits.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Christina" wrote in message
...
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?

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

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?