__Microsoft Excel Hints and Tips__

__Question__

I have two dates and would like to calculate the number of years, months
and days between them. For example, if my dates are 13 May 2002 and 28 March
2006 - then the result should be 3 years, 10 months, and 15 days. Is there
an Excel function to do this ?

__Solution__

There is a function in Excel called *DATEDIF* that does not appear within
the *Insert Function dialog box*. Lets say you have entered your starting
date in cell A1 and your ending date in cell B1.

Type **=DATEDIF(A1,B1,"y")** to calculate the number of years.

Type **=DATEDIF(A1,B1,"ym")** to calculate the number of months.

Type **=DATEDIF(A1,B1,"md")** to calculate the number of days.

Type **=DATEDIF(A1,B1,"y")&" Years,"&DATEDIF(A1,B1,"ym")&"
Months,"&DATEDIF(A1,B1,"md")&" Days"** to calculate years, months, and
days all together.

Return to Excel Exchange homepage.