#Word insert subscript into fraction how to
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 insert subscript into fraction download
You can download this Calculate Age Excel Template here – Calculate Age Excel Template Example #1 – Calculate Age in Excel
0 kommentar(er)
