Calculate age

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
with the DOB in A1 try

=DATEDIF(A1,TODAY,"Y") & " Years, " & DATEDIF(A1,TODAY,"YM") & " Months, " &
DATEDIF(A1,TODAY,"MD") & " Days"
 
Note that you need to be careful with this:

First, TODAY should be TODAY(), unless TODAY is a name in the workbook.

Second, given the way the "md" switch works, calculations are based on
the length of the first month. so:

A1: 31 January 2007
A2: 1 March 2007
A3: =DATEDIF(A1,A2,"Y") & " Years, " & DATEDIF(A1,A2,"YM") & "
Months, " & DATEDIF(A1,A2,"MD") & " Days"

returns

0 Years, 1 Months, -2 Days

in A3. That's usually not what is desired.
 
sorry typo

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