Home > Science and technology > Applications and software

# How to calculate age in Microsoft Excel

Today, most of us rely on technology to do even the smallest things. You may not have thought that you can use Excel to calculate a person's age. To find a person's age in Microsoft Excel, you can use a function that displays your age by year, month, and even day. To use Excel for this purpose, you need to know a few things. The subject of this fascinating article from BingMag is to teach you how to calculate age in Microsoft Excel. So if you would like to use this special and exciting feature, follow us to the end of this article.

Note: We used the day-month-year template in the examples in this article, but you can Use any historical format you like.

In teaching us how to calculate age in Microsoft Excel, we have several methods that we will thoroughly review for you along with the images. These methods are:

## 1) How to calculate age by year

To calculate the age of people by year, you must use the DATEDIF function in Excel. This function takes the date of birth as input and then gives you the age as output.

For this example, we use the following page. On this page, the date of birth in cell B2 is specified and we show the age in cell C2.

First, click on cell C2 to display the age by year.

In cell C2, type the following function and press Enter. In this function, "B2" refers to the date of birth. "() TODAY" also finds the date today, and "Y" indicates that you want to see the age as a year.

and immediately, you will see the age in cell C2.

Note: If you see the date in cell C2 instead of the year, follow these steps:

• In the Number section, click the Date drop-down menu.
• Now click General.
• Now you see the number of years instead of the date.

## 2) How to calculate age by month

You can also use the DATEDIF function to find the age of people Use also by month. For this example, we use the above page data again, which is as follows:

On this page, we click on the C2 cell that we want to show the age in terms of the month.

In cell C2, type the following function. The "M" argument in this section tells the function to show us the result in terms of the month.

Now press Enter and see the age in months in cell C2.

## 3) Number of days elapsed from the age of one

In the third part of the article How to calculate age in Microsoft Excel, we must examine together how we can calculate the number of days elapsed from the age of one in Excel do. In fact, the subject of this section is teaching how to calculate a person's age, according to the day. Excel DATEDIF function is so powerful that you can use it to find the age of people by day. To show it to you again, we use the following page:

On this page, We need to click on the C2 cell that we want to display the age in terms of days.

Cell C2 Type the following function. In this function, the "D" argument tells the function to display the age in terms of days to the user.

At this point, you must press Enter to see the age in cell C2 by day.

Everyone can also use Excel to add and subtract dates.

## 4) How to calculate age in terms of year, month and day at the same time?

Now that you have learned the previous three methods, it is best to combine all three so that you can easily see a person's age in Excel by year, month, and day. Use the DATEDIF function by combining all arguments to display the age of people by year, month and day at the same time. You can also view text in just one cell in your Excel instead of multiple cells. We use the following page for this calculation:

On this page, click on cell C2 we do. Then type the following function and press the Enter key:

Continue the following function In Excel you can see:

in cell C2, age by year, month and day You will see.

Easy!

## 5) How to calculate age on a specific date

Using the DATEDIF function in Excel, you can find the age of people on a specific date that you want. To show you how this function works, use the page below again. In cell C2, we specify the date on which we want to find the age.

, We click on cell D2 to show us the age in the next steps, in this section.

In cell D2, type the following function. In this function, "C2" refers to the cell in which we entered a specific date, based on which our final answer would be:

Now you have to press Enter to see the age in cell D2.

This way, you can calculate the age of anything on a specific date you want.

• 8 tips for Learn Microsoft Excel fast

Source: Howtogeek

### READ NEXT IN: science and technology / applications and software

applications and software

## How to send messages to people on WhatsApp without saving their numbers?

WhatsApp is arguably one of the most popular messaging apps in the world. WhatsApp offers a lot of features to its users, which make the messaging process a little more fun. Since we all use WhatsApp,

applications and software

## The CEO of Twitter did not appear and fired two senior managers of the company

On Monday last week, Twitter co-founder Jack Dorsey announced that he was leaving the company and its chief technology officer. Zaman, Parag Agrawal, will take over as Twitter's new CEO.

applications and software

## Introducing the top 6 WiFi network analysis applications for Android

Wi-Fi technology has spread a lot these days and can almost be said to have become an integral part of our daily lives. So the slightest interruption in connecting to these radio waves can be very ann

applications and software

## Microsoft unveils new Office interface for the general public this week

Microsoft will add a new Office suite to the app this week in an update that all users will have access to.