Calculating Years, Months & Days

[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.

 

[Peo Sjoblom]

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

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/datedif.htm

 

[Phillip Holdsworth]

Thank you for your help Peo!

Regards
Phill Holdsworth