Use the following formula in the cell you want the age of person to appear.

=DATEDIF(A5, NOW(), "y") & " yr, " & DATEDIF(A5, NOW(), "ym") & " mo"

This formula would be in B5 and the persons DOB would be in A5

Hope this helps.

"dallyup2" wrote:

How do you calculate age by a birth date I need years and months... if the
person is not a year old I need to know how many months... if the person is
1yr 2mo I need it to return 1yr 2mo... if the person is only 2mo I need it to
return 2mo.. is there any kind of formula that could work...

Thanks Donna