Date Calculations

R

Rob E

I am trying to take 1 date away from another, but instead
of displaying the result in the number of days, I would
like the result in years, months and days e.g. 3 yrs 2
months 5 days.

Is there an accurate way to do this (taking in to account
leap years)?

Any help would be appreciated.

Thanks,

Robin.
 
M

Myrna Larson

=DATEDIF(A1,B1,"y") gives the years.

Use "ym" and "md" for the months and days. The latter give the number of
months in the final (partial) year and the number of days in the final
(partial) month.
 
Top