Calculate age
 

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

Calculate age
 

One way:

=DATEDIF(A1,TODAY(),"y")

See

http://cpearson.com/excel/datedif.htm

for more options.

In article ,
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

Calculate age
 

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

Calculate age
 

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.



In article ,
Mike wrote:

with the DOB in A1 try

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

Calculate age
 

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