Formula functions - age

More
6 months 2 days ago #10569 by rafiei71
Formula functions - age was created by rafiei71
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.

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago - 6 months 2 days ago #10570 by bert
Replied by bert on topic Formula functions - age
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

Attachments:
Last edit: 6 months 2 days ago by bert.

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago #10571 by rafiei71
Replied by rafiei71 on topic Formula functions - age
Thank you for the prompt reply. Unfortunately, I’m not sure how to input the source data; date of birth etc.

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago #10572 by bert
Replied by bert on topic Formula functions - age
Double tap on the student's name

Attachments:

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago #10573 by rafiei71
Replied by rafiei71 on topic Formula functions - age
Is it possible to input the birthdates in a column, like an excel list? What is the acceptable format to do this? Thx.

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago #10575 by bert
Replied by bert on topic Formula functions - age
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.

Please Log in or Create an account to join the conversation.