98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Getting Age from Date of Birth Formula
Getting Age from Date of Birth Formula
Resolved · Low Priority · Version Standard
Mon 11 Feb 2008, 09:42Delegate James said...
James has attended:
Excel Intermediate course
Getting Age from Date of Birth Formula
I have exported some data to excel, which has the candidate date fo birth, I know there is a formula within excel allowing it calculate the age for all those candidates....Does anyone know how to do it?
Fingers crossed
Thanks in advance.....a Swift response would be appreciated.
Mon 11 Feb 2008, 12:31Trainer Stephen said...
RE: Getting Age from Date of Birth Formula
Hi James
Thank you for your question
There is a little known function in Excel called Datediff() and it calculates the difference between 2 dates.
The syntax would be as follows
=DATEDIF(F9,TODAY(),"y")
F9 is the cell containing the person's date of birth
Today() is a function that returns today's date
"y" specified that the difference be measured in years.( "m" would measure it in months etc.)
Hope this helps
Regards
Stephen
Wed 19 Mar 2008, 11:35Delegate James said...
RE: Getting Age from Date of Birth Formula
Stephen
I have 2 colums one with DOB and other with todays date the forumla you have given me does not seem to work....the 'y' seems to be an issue..should y have a set value?
Let me know
tHanks
Fri 28 Mar 2008, 09:59Trainer Rich said...
RE: Getting Age from Date of Birth Formula
The 'y' (third parameter) indicates that datediff returns the result in years. So if that's what you want, you should keep it as y.
Try copying Stephen's formula from above and just change the first parameter to the cell reference of the DOB you want to calculate.
Regards, Rich
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. |
Excel tip:Stop Formula Returning A "#DIV/0" ErrorIf a formula returns a #DIV/0 error message there is a way to avoid such results. |
