Forum Discussion
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?
- pefirdCopper 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
- pefirdCopper Contributor
Try this
=INT((C1-D1)/365.25)
C1 = Testing date
D1 = Birth date