getting age date birth
Request a callback

We'll call during UK business hours

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


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



Wed 19 Mar 2008, 11:35 replyReply Delegate James said...

RE: Getting Age from Date of Birth Formula


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


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!


Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

Training courses
London & UK

Live dates & prices »

On-site training

Get a quote »


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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel training
Course rating
4.7 stars - based on 27607 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: Google+ · Facebook · Twitter · LinkedIn · Pinterest

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