SOLVED

New Contributor

Date of age with fraction

Hello everyone!

I usually calculate the date of people turning different ages, but I struggle to calculate when ages are given fraction part. For example, I know my clients birthday and should find date when he/she turns 74,4.

I've tried many functions, but couldn't find a solution. I am tired of calculating on paper, it would be great I could calculate it with the helpm of Excell.

5 Replies

Re: Date of age with fraction

Hello @khujaabbos,

That could be:

=[Birthdate]+[Decimal_Age]*365.2422

Note that we account for leap years by using the exact amount of days per revolution around the sun (365.2422 days).

You can use the formula:

=YEARFRAC([DATE])

To verify the decimal age is correct.

Re: Date of age with fraction

I wonder, what is the benefit of such a calculation?

Re: Date of age with fraction

Average lifespan of both males and females are given in this form, and our clients will be recieving insurance benefits till this date. Therefore, I need to know when to stop them recieving insurance benefits.

Re: Date of age with fraction

Hello @PReagan!,

Thank you so much for your reply. Unfortunately, I didn't understand the first part of the reply. Could you show it with an example? And was it supposed to be done on Excell?

Best Response confirmed by khujaabbos (New Contributor)
Solution

Re: Date of age with fraction

[Birthday] represents a cell that contains the participants birthday. For example, B1 = 1/1/1946

[Decimal_Age] represents a cell that contain the participants age in decimal format. For example B2 = 74.4

The number 365.2422 represents the exact amount of days in a year.

Using the formula, the date in which the participant turns 74.4 is:

=B1+B2*365.2422 or 5/26/2020

You can use YEARFRAC(B1,B3) to verify that the decimal age is correct.