Aug 27 2020 06:50 AM
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.
Thanks in advance.
Aug 27 2020 07:15 AM
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.
Aug 27 2020 10:17 AM
Aug 27 2020 09:40 PM - edited Aug 27 2020 09:53 PM
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.
Aug 27 2020 09:52 PM
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?
Thanks in advance.
Aug 28 2020 08:29 AM
Solution
[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.
Aug 28 2020 08:29 AM
Solution
[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.