How

How to calculate age in Microsoft Excel

To find the age of someone or something 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 an Excel spreadsheet.

MS excel logo 675 - How to calculate age in Microsoft Excel

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

How to calculate age in years

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

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

1 age years spreadsheet - How to calculate age in Microsoft Excel

First, we will click on the cell C2 Where we want to display the age in years.

2 c2 cell spreadsheet - How to calculate age in Microsoft Excel

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

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

3 enter year formula - How to calculate age in Microsoft Excel

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

Note: If you see a date instead of years in cell C2, in the Home > Number section in Excel, click the Date dropdown and select Year. You will now see years instead of a date.

4 age years answer - How to calculate age in Microsoft Excel

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

How to calculate age in months

You can use the DATEDIF function to find out someone’s age in months as well.

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

5 age months spreadsheet - How to calculate age in Microsoft Excel

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

6 c2 cell - How to calculate age in Microsoft Excel

And in cell C2, we will write the following function. The “M” argument tells the function to return the result in months.

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

7 enter month formula - How to calculate age in Microsoft Excel

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

8 age months answer - How to calculate age in Microsoft Excel

How to calculate age in days

The Excel DATEDIF function is so powerful that you can use it to find someone’s age in days as well.
To show you a demo, we’ll use the following spreadsheet:

9 age days spreadsheet - How to calculate age in Microsoft Excel

In this spreadsheet we will click on cell C2 where we want to display the age in days.

10 c2 cell - How to calculate age in Microsoft Excel

And in cell C2, we will write the following function. In this function, the argument “D” tells the function to display the age in days.

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

11 enter day formula - How to calculate age in Microsoft Excel

Click on Enter And you’ll see the age in days in cell C2.

12 age days answer - How to calculate age in Microsoft Excel

How do you 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 arguments combined. You can also combine text from multiple cells into a single cell in Excel.

We’ll use the following spreadsheet for the calculation:

13 age combination spreadsheet - How to calculate age in Microsoft Excel

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

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

14 enter age formula - How to calculate age in Microsoft Excel

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

15 age combination answer - How to calculate age in Microsoft Excel

How to calculate age on a specific date

Using the DATEDIF function in Excel, you can search for someone’s age on a specific date.

To illustrate how this works, we will use the following spreadsheet. In cell C2, we have specified the date in which we want to find the age.

16 specific date - How to calculate age in Microsoft Excel

We will click on cell D2 where we want to show the age on the given date.

17 d2 cell - How to calculate age in Microsoft Excel

In cell D2, we will write the following function. In this function, “C2” refers to the cell in which we entered the specified date, on which the answer will be based:

=DATEDIF(B2,C2,"Y")

18 enter specific formula - How to calculate age in Microsoft Excel

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

19 specific formula answer - How to calculate age in Microsoft Excel

And that’s how you find someone or something out of date in Microsoft Excel!

Using Excel, did you know that you can find the number of days left on an event? This is very useful if you are looking forward to an important event in your life!

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker