How to Calculate Age in Excel
Learn: The Quick & easy way on How to Calculate Age in Excel
In this video, you will learn:
1. How to Calculate Age in Excel
2. How to know your age in Excel
To calculate Age in Excel, we must have the Date of Birth of that person. We can calculate the age in excel with the help of the TODAY function. For this, select the cell which has the Date Of Birth, and subtract this Date of Birth from today’s date, which we can get using the TODAY function. This would give us the number of days from the selected Date of birth to till date. And then divide that by 365, which is the actual number of days in a Year. This would give the Age of that person to date.
Let’s find the steps to calculate age in excel.
In excel, we can calculate the age of a person if we know the person’s date of birth and the current date. Consider the example I have on this table where we have the current date and date of birth.
Here we can use the simple logical formula to find out the Age by using below formula.
= (D4-C4)/365.25 which gives you the result here.
Here we have just subtracted the current date- date of birth/365.25 why I have used 365.25 because, in order to get an account for a leap year which appears every 4 years, it will not give us the appropriate result because we got an age output in decimal places, so in order to round off the value, we can use the “ROUNDDOWN function which is normally used to round down the decimal places.
ROUNDDOWN is used to round down the number, and num_digit is used to round down the number to many decimal places.
=ROUNDDOWN ((D4-C4)/362.25, 0) will give the roundup values shown in the below result.
In the result on my screen, we can see the difference. After applying the round-down function, we got the exact output of 62; before that, we got the same age output as 62.96
Now we will see how to calculate Age in excel by using the built-in function called DATEDIF function
The DATEDIF function is the built-in function in excel where it returns the difference between the two date values in years, months, or days.
In DATEDIF function Formula in Excel, we have Arguments & Parameters to Calculate Age in Excel. These are:
Start date: – Represents the start date where we will enter a text string.
End date: – Represents the end date where we will enter a text string.
Unit: – This will find the time unit based on the specified text string such as Years, Months, and dates. i.e. (Y, M, D, MD, YM, YD) in “double-quotes”.
Y:-represents Year’s unit
M: - represents Month’s Unit
D: – represents Day Unit
MD: – represents Month Day Unit
YM:- represents Year Month
YD: – T represents Year Date Unit
Now let us Use the DATEDIF Function to calculate the Year month and Days using the above specified text string. I.e. Y, M, D, MD, YM, YD
In Microsoft, excel DATEDIF is a compatibility function where we need to use the formula correctly. Like other functions, the DATEDIF function will not help if we apply the wrong data, and also, it will not show the arguments while using the function.
In this table on my screen, we will see how to calculate age using the DATEDIF function. In order to calculate the age of any specific person, we need two things, the date of birth and the current date, so that we can apply the DATEDIF function
Let us consider the above example where it has Staff name, department, date of birth, and current date, and I have also created three new columns Year, Month, and Day to get the output.
First, we will see how to calculate the age excel of the staff using the DATEDIF function.
• First, click on cell G4, which is nothing but the Year column.
• Now apply the DATEDIF function in excel i.e.
=DATEDIF(C4, D4, “Y”), C4 is nothing but the date of birth , D4 is the current date of the year, “Y” which will return the total completed years.
• See how we have applied the formula in excel, which is shown here. We can see the DATEDIF function calculated with the “Age” as 62.
• Now drag down the formulas to all the cells so that we will come to know the age of all staff.
Also, let us also use the same DATEDIF function to find out the Month of the staff, i.e. on which month exactly he/she was born. To find out the month of a staff, follow the below steps follows.
• First, click on the H4 cell, which is nothing but the Month Column.
• Now apply the DATEDIF function in excel as shown below=DATEDIF(C4, D4, “YM”), NOTE: “YM” which will return the difference in months.
• You can see the DATEDIF function calculated with the difference of “month” of the first staff as 11.
……………………………………………………………………………………………………………………….
Share this video: • How to Calculate Age in Excel
For more simple and easy to follow How to videos,
Click the Link Below to subscribe:
/ @learnexcelwitht
Join this channel to get access to the perks:
/ @learnexcelwitht
#calculateage #calculateyear #dateofbirth
LearnexcelwithT
Смотрите видео How to Calculate Age in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь LearnexcelwithT 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 186 раз и оно понравилось 78 людям.