How to Calculate Age Range From Birth Date in An Excel Spreadsheet

Written by elizabeth wolfenden
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate Age Range From Birth Date in An Excel Spreadsheet
Happy Birthday! (http://www.sxc.hu/photo/1006129 (Nazreth))

Ever wonder the exact age of someone? Not just how many years old the person is, but his age down to the very second? If so, this Excel activity is the perfect solution. By simply entering today's date, the birth date and a few simple functions, the program can calculate a person's age in years, months, days, hours and even seconds. Follow the steps and easily calculate the age range from any birth date in an Excel spreadsheet.

Skill level:
Easy

Other People Are Reading

Things you need

  • Computer
  • Microsoft Excel program

Show MoreHide

Instructions

  1. 1

    Enter the date data. In cell A1, type in today's date. In cell A2, type in the person's birth date.

  2. 2

    Enter the formula to display the age in years. In cell A3, enter the following formula: "=(A1-A2)/365.25." Then click "Enter." The result displayed is the person's age in years.

  3. 3

    Type the formula to display the age in months. In cell A4, enter the formula "=A3*12" and click "Enter." The person's age in months will display.

  4. 4

    Enter the formula to display the age in days. In cell A5, enter the formula "=A3*365.25" and hit "Enter." The person's age in days will show.

  5. 5

    Type the formula to display the age in hours. In cell A6, enter "=A5*24" and click "Enter." The person's age in hours will display.

  6. 6

    To show the person's age in seconds, type the formula "=A6*60" into cell A7 and click "Enter." The number displayed is the person's age in seconds.

Tips and warnings

  • Type the dates in normal date format (mm/dd/yy) and Excel should recognise it, but if not, right-click on the cell, click "Format" and change the format from the default number to the date format.
  • Because of how Excel makes these calculations, these formulas might not work properly for someone who is less than a year old.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.