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