Note that using "md" bases days in a month on the number of days in the
month of the first argument, so you can get some weird results, like:

A6: 1/31/2007
A7: 3/01/2007

results in

0years,1months,-2days,



In article ,
Jean wrote:

thx a lot! that really helps!! thank you!

"Gord Dibben" wrote:

Jean

Date 1 in A6................Date 2 in A7

=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"