getting age date birth
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

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

resolvedResolved · Low Priority · Version Standard

Mon 11 Feb 2008, 09:42 replyReply Delegate 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.

For upcoming training course dates see: Pricing & availability

Mon 11 Feb 2008, 12:31 replyReply Trainer 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:35 replyReply Delegate 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:59 replyReply Trainer 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

Fri 13 Mar 2009, 15:14 replyReply Delegate James said...

RE: Getting Age from Date of Birth Formula

I am now using the new excel 2007 instead of 2003 version and the formula does not appear to work, has the formula changed with the new 2007 version?

Fri 13 Mar 2009, 15:21 replyReply Delegate James said...

RE: Getting Age from Date of Birth Formula

Dont worry I have figured it out!

 

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips



MS Project training
Course rating:
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom