Thread: Can you calculate the number of years between two dates in Excel 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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?
Reply With QuoteReply With Quote