Giving the age to three significant figures, implicitly leads the reader to assume a level of accuracy that may not be borne out of you ask a selection of people what it means. In general, I would suggest that you steer clear of representing someones age as ''40.3'' if at all possible. What exactly would you mean by 0.3 of a year?Д®xcel has functions that will 'standardise' those period, and resolve the issue that you are encountering by assuming that every year has 360 days, and every month exactly 30 days. A year can be either 365 or 366 days, and is therefore, not well defined either as a measure of time.

The same problem arises for a 'year' - as discussed above. You subtract a particular date with the Date of Birth (DoB) to get the age number.

This mysterious function doesnt appear in Excels Help files. Therefore, it is difficult to use a 'month' as a measure of time (as opposed to an absolute time reference for which it is very well defined). Age calculation is basically a subtraction process. One of the easiest ways to calculate the age of anything is to use Excels DATEDIF function. This calculator computes BMI and BMI percentiles for individual children in a group using height and weight measurements, sex, date of birth, and date of. The problem is that a month is not a well defined period of time (can be anything from 28 days to 31 days inclusive).

Excel calculate age from date