Forum Discussion

marianne's avatar
marianne
Copper Contributor
Dec 30, 2024

Formula for age

Formula for age of a participant of a study whos doing training, with the birth day and the start date of training . I used the formula: fx=DATEDIF(H1;T1;"Y"). where H is the column of birthday and T the column of trainingsdate. the adminstrator has defined the dates for each column between 2018-2040. As the birthdays are all before 2018, i get an error  and can not do the calculation of age in this way...is there another possibility to calculate the age of the participant?

 

 

3 Replies

  • Can you enter the birth dates in a column that does not have a data validation rule (Datenüberprüfingsregel)?

    Alternatively, can you remove the data validation rule from column H?

    • pefird's avatar
      pefird
      Copper Contributor

      Not sure what the data validation is doing. 

      This formula will give you age.

      =INT((C1-A1)/365.25)

      C1 = Date of Training

      A1 = Date of Birth

  • pefird's avatar
    pefird
    Copper Contributor

    Try this

    =INT((C1-D1)/365.25)

    C1 = Testing date

    D1 = Birth date

Resources