Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 22
13 July 2003

Start each week with a free tip

To subscribe, please type your email address in the box below:

Calculating a person's age (Microsoft Excel)

Did you know ...

you can use Excel's DATEDIF worksheet function to calculate somebody's age based on date of birth?

Here's how:

  1. Enter the person's date of birth in, say, cell A1
  2. Select the cell in which the age is to appear (say, B1) and enter the following formula: =DATEDIF(A1, TODAY(), "y")
  3. Press ENTER

Using Excel's AutoFill feature, you can then quickly enter the formula into a range of cells. Here's how:

  1. Enter other dates in, say, cell A2, A3, A4, A5
  2. Select cell B1
  3. Point to the fill handle (the small black square) in the lower-right corner of cell B1. The mouse pointer will appear as a thin black cross when it is properly positioned
  4. Press and hold down the mouse button, and drag the fill handle to cell B5
  5. Then release the mouse button

The selected range is filled with the calculated age based on the date of birth in cell A1, A2, A3, A4 and A5.

Until next week.

Email this page to a friend

Enter recipient's email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
July 2003