How do I put in a formula in Exel to calculate a persons age?

B

boofire19

I have a formula in for someones age but it shows me their age that they will
be this year. How do I get it so it shows the correct age and then changes on
their birthday.
 
G

Gord Dibben

=DATEDIF(A1,TODAY(),"y") & " years old"

Assumes birthdate in A1

If you want a more detailed message............

=DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & "
months,"& DATEDIF(A1,TODAY(),"md") & " days old"


Gord Dibben MS Excel MVP
 
A

Ashish Mathur

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
C

CellShocked

=CONCATENATE("This person is ",(DATEDIF(A1,TODAY(),"y") & " years, " &
DATEDIF(A1,TODAY(),"ym") & "months, "& DATEDIF(A1,TODAY(),"md") & " days
old"))


It is yours with the addition of "This person is..." as a prefix.
 
L

Lil Red Riding In The Hood

Why can I not find "DATEDIF" in the function reference in the help file?
 
D

Duke Carey

If you have the Analysis Toolpack add-in (Tools menu, choose Add-ins and
check Analysis toolpack) you can also use

=INT(DAYS360(birthdate,TODAY())/360)
 

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

How to use/create code in MS Word to calculate age? 0
New computer, how do i move outlook 365 ENTIRELY? 0
Calculate horses age as at 1 August 6
"how do I calculate age by using date of birth details" 6
Please help with formula (multiple ifs to determine due date) 3
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Age Formula 15
Birth date from age 2

Top