Date Calculations

  • Thread starter Thread starter Rob E
  • Start date Start date
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.
 
=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.
 
Back
Top