I've run a quick check on this formula. It doesn't seem to include
additional leap year days.

Regards.

Bill Ridgeway
Computer Solutions

"Mike" wrote in message
...
=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