Forum Discussion
Solved
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 ...
[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.
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.