Microsoft Excel Logo

To find someone or something’s age in Microsoft Excel, you can use a function that displays the age in years, months, and even days. We’ll show you how to use this function in your Excel spreadsheet.

Note: We’ve used the day-month-year format in the examples in this guide, but you can use any date format you prefer.

RELATED: Why Do You Need Formulas and Functions?

How to Calculate Age in Years

To calculate someone’s age in years, use Excel’s DATEDIF function. This function takes the date of birth as an input and then generates the age as an output.

For this example, we’ll use the following spreadsheet. In the spreadsheet, the date of birth is specified in the B2 cell, and we’ll display the age in the C2 cell.

A sample spreadsheet to find age in years in Excel.

First, we’ll click the C2 cell where we want to display the age in years.

Click the C2 cell in the spreadsheet in Excel.

In the C2 cell, we’ll type the following function and press Enter. In this function, “B2” refers to the date of birth, “TODAY()” finds today’s date, and “Y” indicates that you wish to see the age in years.

=DATEDIF(B2,TODAY(),"Y")

Type =DATEDIF(B2,TODAY(),"Y") in the C2 cell and press Enter in Excel.

Advertisement

And immediately, you’ll see the completed age in the C2 cell.

Note: If you see a date instead of years in the C2 cell, then in Excel’s Home > Number section, click the “Date” drop-down menu and select “General.” You’ll now see years instead of a date.

Age in years in Excel.

Excel is so powerful that you can even use it to calculate uncertainty.

RELATED: How to Get Microsoft Excel to Calculate Uncertainty

How to Calculate Age in Months

You can use the DATEDIF function to find someone’s age in months, too.

For this example, again, we’ll use the data from the above spreadsheet, which looks like this:

A sample spreadsheet to find age in months in Excel.

In this spreadsheet, we’ll click the C2 cell where we want to display the age in months.

Click the C2 cell in the spreadsheet in Excel.

In the C2 cell, we’ll type the following function. The “M” argument here tells the function to display the result in months.

=DATEDIF(B2,TODAY(),"M")

Enter =DATEDIF(B2,TODAY(),"M") in the C2 cell in Excel.

Advertisement

Press Enter and you’ll see the age in months in the C2 cell.

Age in months in Excel.

How to Calculate Age in Days

Excel’s DATEDIF function is so powerful that you can use it to find someone’s age in days as well.

To show you a demonstration, we’ll use the following spreadsheet:

A sample spreadsheet to find age in days in Excel.

In this spreadsheet, we’ll click the C2 cell where we want to display the age in days.

Click the C2 cell in the spreadsheet in Excel.

In the C2 cell, we’ll type the following function. In this function, the “D” argument tells the function to display the age in days.

=DATEDIF(B2,TODAY(),"D")

Type =DATEDIF(B2,TODAY(),"D") in the C2 cell in Excel.

Press Enter and you’ll see the age in days in the C2 cell.

Age in days in Excel.

Advertisement

You can use Excel to add and subtract dates, too.

How to Calculate Age in Years, Months, and Days at the Same Time

To display someone’s age in years, months, and days at the same time, use the DATEDIF function with all the arguments combined. You can also combine text from multiple cells into one cell in Excel.

We’ll use the following spreadsheet for the calculation:

A sample spreadsheet to find age in years, months, and days in Excel.

In this spreadsheet, we’ll click the C2 cell, type the following function, and press Enter:

=DATEDIF(B2,TODAY(),"Y") & " Years " & DATEDIF(B2,TODAY(),"YM") & " Months " & DATEDIF(B2,TODAY(),"MD") & " Days"

Enter =DATEDIF(B2,TODAY(),"Y") & " Years " & DATEDIF(B2,TODAY(),"YM") & " Months " & DATEDIF(B2,TODAY(),"MD") & " Days" in the C2 cell and press Enter in Excel.

In the C2 cell, you’ll see the age in years, months, and days.

Age in years, months, and days in Excel.

How to Calculate Age on a Specific Date

With Excel’s DATEDIF function, you can go as far as to finding someone’s age on a specific date.

To show you how this works, we’ll use the following spreadsheet. In the C2 cell, we’ve specified the date on which we want to find the age.

A specific date in the C2 cell in Excel.

Advertisement

We’ll click the D2 cell where we want to show the age on the specified date.

Click the D2 cell in Excel.

In the D2 cell, we’ll type the following function. In this function, “C2” refers to the cell where we’ve entered the specific date, on which the answer will be based:

=DATEDIF(B2,C2,"Y")

Enter =DATEDIF(B2,C2,"Y") in the D2 cell in Excel.

Press Enter and you’ll see the age in years in the D2 cell.

Age on a specific date in the D2 cell in Excel.

And that’s how you find someone or something’s oldness in Microsoft Excel!


With Excel, did you know you can find how many days until an event? This is super useful if you’re looking forward to an important event in your life!

RELATED: Use Excel to Calculate How Many Days Until an Event

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.