Here in the above screenshot, we can see the DATEDIF function calculated with the “Age” of an employee as 40. Let’s see how we have applied the formula in excel, which is shown below.Now apply the DATEDIF function in excel as shown below=DATEDIF(C2, D2, “Y”), C2 is nothing but the date of birth of the employee, D2 is the current date of the year, “Y” which will return the total completed years.First, click in cell E2, which is nothing but the Year column.
Word shortcut for format painter how to#
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 by following the below steps.Ĭonsider the below example where it has an employee name, designation, date of birth, current date, and we have also created three new columns like Year, Month, Day to get the output.įirst, we will see how to calculate the age in excel of the employee using the DATEDIF function. In this example, we will see how to calculate age using the DATEDIF function. 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, which is shown below. In Microsoft, excel DATEDIF is a compatibility function where we need to use the formula correctly. YD: – This Year Date Unit will find the difference in Days, but it will ignore the years.Įxample #2 – Calculating Using the DATEDIF Function.YM:-This Year Month Unit will find the difference in months, but it will ignore days and years.MD: – This Month Day Unit will find the difference in days, but it will ignore months and years.D: – This Day Unit will find the number of Completed days.M:-This Month Unit will find the number for completed months.Y:-This Year unit, which will find the number of completed years.Unit: – This will find the time unit based on the specified text string such as Years, Months, date.End date: – Represents the end date where we will enter a text string.Start date: – Represents the start date where we will enter a text string.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.Īrguments & Parameters to Calculate Age in Excel Now we will see how to calculate Age in excel by using the built-in function. After applying the round down function, we got the exact output as 37 before that, we got the same age output as 37.44 In the below result, we can see the difference. =ROUNDDOWN((B1-B2)/362.25,0) will give the roundup values shown in the below result. =ROUNDDOWN (Number, num_digit) where the number is used to round down the number, and num_digit is used to round down the number to many decimal places. Here we have just subtracted the current date- date of birth/365.25 why we 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. = (B1-B2)/365.25 gives you the result as shown below. Here we can use the simple logical formula to find out the Age by using the below formula. Consider the below example where we have the current date and date of birth. In excel, we can calculate the age of a person if we know the person’s date of birth and the current date.
Word shortcut for format painter download#
You can download this Calculate Age Excel Template here – Calculate Age Excel Template Example #1 – Calculate Age in Excel
0 kommentar(er)
