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

ResolvedVersion Standard

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

Mon 11 Feb 2008, 12:31 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 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 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 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 Delegate James said...

RE: Getting Age from Date of Birth Formula

Dont worry I have figured it out!

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips

Getting Age from Date of Birth Formula

Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

Excel articles

Excel tip:

Change the Print button so it brings up the Print dialogue box