Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculate age formula
|
|
|
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. |
Calculate age formula
Resolved · Medium Priority · Version 2003
Reply Fri 7 Oct 2011, 13:28Delegate Joan said...
Joan has attended:
Excel Introduction course
Calculate age formula
How do I enter date of birth, then find age at various dates from today onwards
For upcoming training course dates see: Pricing & availability
RE: Calculate age formula
Hi Joan
Enter your date of birth into cell A1 in this format 00/00/0000, replace the 0 with your actual DOB
In cell A2 enter a future date.
In cell A3 enter this formula =A2-A1
In cell A4 enter this formula =A3/365.25
You can now enter any date into cell A2 and excel will calculate your age at that given date.
Does that help?
Kind Regards
Paul
|