Forum Discussion

khujaabbos's avatar
khujaabbos
Copper Contributor
Aug 27, 2020
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 ...
excel
Formulas and Functions
Macros and VBA
  • PReagan's avatar
    PReagan
    Aug 28, 2020

    khujaabbos 

     

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

     

khujaabbos's avatar
khujaabbos
Copper Contributor
Aug 28, 2020

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.

PReagan's avatar
PReagan
Bronze Contributor
Aug 28, 2020

khujaabbos 

 

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

 

Resources