Calculating Years, Months & Days

  • Thread starter Thread starter Phillip Holdsworth
  • Start date Start date
P

Phillip Holdsworth

I want to calculate a period of time between two dates
and return a number in years, months and days in a single
cell, taking account of leap years.

Can anyone tell me how this could be done.

Thanks.
 
With a few exceptions this will work

=DATEDIF(A1,B1,"y")&" year(s), "&DATEDIF(A1,B1,"ym")&" month(s) and
"&DATEDIF(A1,B1,"md")&" day(s)"

where A1 is the start date and B1 the end date

for the exceptions make a google search on DATEDIF
 
Back
Top