Cart 0

How to calculate a person's age in Excel

Posted by Roger Hyttinen on

If you need to calculate a person’s current age based on their birthday, you can do this with a simply formula in Excel. When I worked in an HR office, I often had to fill out forms providing the birth date and current age for specific employees. What I did, was add the age calculation formula to my main Employee spreadsheet, so that it updated every time I opened the file.

Excel spreadsheet that calculates age

To Calculate Age in Excel:

  1. Select the cells containing the date of birth.
  2. Right-click and choose Format Cells from the contextual menu.
  3. Click Date in the Category pane.
  4. Choose the Date format you want and click OK.  
    Date format list
  5. Click in the cell where you want the person’s calculated age to appear.
  6. Enter the formula: =(NOW()-A2)/365.24 (where A2 is the cell reference containing the birth date.)
  7. Copy the formula down using the Fill handle.
  8. Select the column containing the calculate age. Now we will get rid of the decimal points.
  9. Click the Number dialog launcher.  
    Number dialog launcher
    Click the Number category in the left pane.
  10. Type 0 in the Decimal Places box.  

Looking for more Excel tips? Check out our new book Excel 2016: Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks

Share this post

← Older Post Newer Post →

Leave a comment

Please note, comments must be approved before they are published.