Calculate age

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
 
G

Guest

with the DOB in A1 try

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

JE McGimpsey

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.
 
G

Guest

sorry typo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating age from date of birth and ignoring if blank 5
How do I post a result of a query to a text box? 0
How do I calculate the age of a subject based on their DOB? 2
Calculate Age in Years and Months? 1
How do I calculate a person's age from date of birth and a date 2
Is there a formula to keep track of age? 2
how to calculate the age of an employee 13
Calculate age 3

Top