How to Calculate Age Using Excel

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

Step

Open the file that has the listing of dates. For demonstration purposes, the dates are in Column A and the age results are displayed in Column B.

Step

Copy and paste the following formula into Cell B2 and fill down:

Step

\=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months "&DATEDIF(A2,TODAY(),"md")&" days"

Step

Look at the results. 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.

Step

To sort the ages, use the Birthday column and select "Ascending" or "Descending" order.