in cell b4 enter:

=DATEDIF(A4,NOW(),"y") & " years, " & DATEDIF(A4,NOW(),"ym") & " months, " &DATEDIF(A4,NOW(),"md") & " days old"

HTH

"Marty" wrote in message ...
About a year ago I found a formula to calculate the number of years, months and days a person had lived just by typing in their birthdate. ie. 13 Jan 1927 cal: 77years, 11months, 3days. Does anyone know what it may be? Thanks.