How to Calculate Age Using Excel

If you need to know the age of something and you have a start date, there is a formula you can use in Excel to calculate the age in year, month, and day format.

Instructions

Difficulty: Moderate

Things You’ll Need:

• Excel
• Basic understanding of Excel formulas

1. Start With Column of Dates Open the file that has the listing of dates. For demonstration purposes, the dates will be in column A and the age results will display in column B
2. Copy and paste the following formula into cell B2 and fill down.
   
   =DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months "&DATEDIF(A2,TODAY(),"md")&" days"
3. Age Displayed The result will show the difference from the current date to include the number of years, months, and days. The best news is that you don’t have to update the formula if you open the file at a later date; the age will automatically recalculate based on the current date.
4. Sort By Birthday To sort the ages, use the birthday column and choose Ascending or Descending order.
5. Final Age List The finalized listing, sorted to show the oldest to the youngest.