On Feb 1, 2:47 pm, Mike wrote:
Assumes DOB is in A1

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



"Rodica" wrote:
What function should I use to calculate the age of a person?- Hide quoted text -

- Show quoted text -

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