getting age date birth

Forum home » Delegate support and help forum » » 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.

For upcoming training course dates see:

Mon 11 Feb 2008, 12:31Trainer Stephen said...

### RE: Getting Age from Date of Birth Formula

Hi James

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

Fri 13 Mar 2009, 15:14Delegate 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:21Delegate James said...

### RE: Getting Age from Date of Birth Formula

Dont worry I have figured it out!

### 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.

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 information: