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. 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. First, we will click on the cell C2 Where we want to display the age in years. 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")` 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. 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: In this spreadsheet, we will click on cell C2 where we want to display the age in months. 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")` Press Enter and you will see the age in months in cell C2. ## 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: In this spreadsheet we will click on cell C2 where we want to display the age in days. 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")` Click on Enter And you’ll see the age in days in cell C2. ## 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: 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"` In cell C2, you will see the age in years, months, and days. ## 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. We will click on cell D2 where we want to show the age on the given date. 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")` Press Enter and you will see the age in years in cell D2. 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!