Home > Science and technology > Applications and software
Reading time estimate: 4 min

How to calculate age in Microsoft Excel

BingMag.com 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.

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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.

BingMag.com How to calculate age in Microsoft Excel

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:

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

BingMag.com How to calculate age in Microsoft Excel

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:

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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.

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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:

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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.

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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:

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

Continue the following function In Excel you can see:

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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.

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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:

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to calculate age in Microsoft Excel

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

BingMag.com How to send messages to people on WhatsApp without saving their numbers? applications and software

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,

BingMag.com The CEO of Twitter did not appear and fired two senior managers of the company applications and software

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.

BingMag.com Introducing the top 6 WiFi network analysis applications for Android applications and software

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

BingMag.com Microsoft unveils new Office interface for the general public this week applications and software

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