Formula functions - age

Thank you for a great app. Can you describe how to use the “age” function in the formula. I wish to create a column where the age can be calculated given the birthdate or birth year. Thx.

Hello rafiei71,

Since age will change over time, in a formula you calculate AGE based on the column's date and the student's date of birth.
If AGE() is left empty with no parameters it will yield a full description of years and months like this image below



If you set AGE(1) it will yield a numeric result with years and months as decimals.
Like this



It is this second combination the one you need for further calculations

Thank you for the prompt reply. Unfortunately, I’m not sure how to input the source data; date of birth etc.

Double tap on the student's name

Is it possible to input the birthdates in a column, like an excel list? What is the acceptable format to do this? Thx.

You can type it as text but it won't be taken into account as the AGE formula does.
You can easily import those dates with an Excel file into the student's personal data sheet
and you can even show that birthdate or age in the gradebook if you need to.