How to Calculate Age in Microsoft Excel

0

Get real time updates directly on you device, subscribe now.

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: 7 Keys to Enhance Your Website Traffic Starting To Day

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.

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 Avoid Downloading Trojans on Android Devices

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.

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.

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.

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!

Subscribe to our newsletter
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
We promise not to span you and you can unsubscribe at any time

Get real time updates directly on you device, subscribe now.

Leave A Reply

Your email address will not be published.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More