Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
7 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Calculating age in Excel
Posted on 2012-04-01
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
Active 5 days ago
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
=(B1-A1)/365.25
where A1 is the DOB and B1 is the current date.
cheers, teylyn
Active 5 days ago
Probably more than you want but - assuming your DOB is in A1:
=INT((TODAY()-A1)/365.25) & " years, " & INT(((TODAY()-A1)/365.25-I
Kevin
=INT((TODAY()-A1)/365.25) & " years, " & INT(((TODAY()-A1)/365.25-I
Kevin
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month7 days, 4 hours left to enroll
724 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.