Calculating age in Excel

Hello,

Given a person's Date of Birth (DOB), what is the simplest formula in Excel that will accurately display that person's current age (in years)? I emphasize "current" because I'm interested in a formula that will auto-update the result each day (i.e. the age will increase automatically on the person's birthday).

Thanks

Steve_Brady

Asked: 2012-04-01

Advertise Here

Microsoft Excel

3 Solutions

LVL 50

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented: 2012-04-01

Until Barryhoudini comes along and posts how to do it correctly, here's my stab

=(B1-A1)/365.25

where A1 is the DOB and B1 is the current date.

cheers, teylyn

LVL 81

zorvek (Kevin Jones)ConsultantCommented: 2012-04-01

Probably more than you want but - assuming your DOB is in A1:

=INT((TODAY()-A1)/365.25) & " years, " & INT(((TODAY()-A1)/365.25-INT((TODAY()-A1)/365.25))*12) & " months, " & TEXT(((TODAY()-A1)/365.25-INT((TODAY()-A1)/365.25)-INT(((TODAY()-A1)/365.25-INT((TODAY()-A1)/365.25))*12)/12)*365.25,"0.0") & " days"

Kevin

LVL 2

KeldenCommented: 2012-04-01

Use this:
B3 is the column with the birthday

=DATEDIF(B3;TODAY();"Y")

Steve_BradyAuthor Commented: 2012-04-21

Thanks

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Expand your skills with this month's free Premium course.

Calculating age in Excel

Join & Write a Comment Already a member? Login.

Featured Post