this will do age Put your birthday in cell A1 and test
=DATEDIF(A1,TODAY(),"Y") & " Years old "

this will do years months and days
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

"Rod Bishop" wrote:

Wanting a formula to calculate a persons age from birth to today's date