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