Thanks for that, I never new about the spurious results

"JE McGimpsey" wrote:

Note that this produces some weird results...

For instance on 3/1/2008:

A2: 1/31/1990
B2: 18 y, 1 m, -1 d


Also - never need to use NOW() rather than TODAY() - the time portion
just gets thrown away.


In article ,
Mike H wrote:

Maybe this in b1 and drag down

=DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
DATEDIF(A1,NOW(),"md") & " d"