Calculate diiference between 2 dates
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"
should do the trick with the dates in A1 & A2
Mike
"Jester" wrote:
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
|