Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to calculate age on a particular date
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
How to calculate age on a particular date
Resolved · Medium Priority · Version 2010
Reply Mon 15 Aug 2011, 16:45Delegate Angela said...
Angela has attended:
Excel Advanced course
Excel
How does one calculate a list of peoples' ages on a particular date easily?
For upcoming training course dates see: Pricing & availability
RE: Excel
Hi Angela
Easiest way to calculate age from someone's date of birth is
- calculate the number of days old they are by subtracting from today's date.
- then divide by 365.25 to get years old.
- the answer had many decimal places so can use the INT function to give a whole number of years.
Here is the formula typed into B2 for my own DOB typed in in A2
Date of Birth Age
26/12/56 =INT((TODAY()-A2)/365.25)
Should say 54
This is accurate to one or two days which is usually acceptable. There is a more accurate but complicated formula as well I can send if you need it.
Regards
Doug
|