Solved

Calculating age in Excel

Posted on 2012-04-01
4
352 Views
Last Modified: 2012-04-21
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
Comment
Question by:Steve_Brady
4 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 250 total points
ID: 37793880
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
 
LVL 81

Assisted Solution

by:zorvek (Kevin Jones)
zorvek (Kevin Jones) earned 125 total points
ID: 37793892
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
 
LVL 2

Assisted Solution

by:Kelden
Kelden earned 125 total points
ID: 37793897
Use this:
B3 is the column with the birthday

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

Author Closing Comment

by:Steve_Brady
ID: 37876542
Thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question