Date String

J

Jester

I have 2 dates and I want to calculate the difference expressed as the
following string:

(eg) 9 Years 3 months and 13 days

Can anyone help?

Many Thanks

John - Sydney Aust.
 
R

RichardSchollar

Hi John

Assuming earlier date in A1 and later date in A2 then you can use the
following formula:

=DATEDIF(A1,A2,"y") & " years " & DATEDIF(A1,A2,"ym") & " months and "
& DATEDIF(A1,A2,"md") & " days"

Hope this helps!

Richard
 
Top