Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

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
0
Steve_Brady
Asked:
Steve_Brady
3 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
0
 
zorvek (Kevin Jones)ConsultantCommented:
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
0
 
KeldenCommented:
Use this:
B3 is the column with the birthday

=DATEDIF(B3;TODAY();"Y")
0
 
Steve_BradyAuthor Commented:
Thanks
0
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now