sorry typo

=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

"Mike" wrote:

with the DOB in A1 try

=DATEDIF(A1,TODAY,"Y") & " Years, " & DATEDIF(A1,TODAY,"YM") & " Months, " &
DATEDIF(A1,TODAY,"MD") & " Days"



"Grd" wrote:

Hi there,

How do I calcuate the age of a person if all I have is their date of birth
in a cell?

Is this possible in excel?

Thanks for your help

Suzanne