iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Formula functions - age

Formula functions - age 1 month 2 days ago #10569

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.
The administrator has disabled public write access.

Formula functions - age 1 month 2 days ago #10570

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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

Screenshot2022-06-02at16.23.23.png


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

Screenshot2022-06-02at16.23.34.png


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

Screenshot2022-06-02at16.28.39.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 1 month 2 days ago by bert.
The administrator has disabled public write access.

Formula functions - age 1 month 2 days ago #10571

Thank you for the prompt reply. Unfortunately, I’m not sure how to input the source data; date of birth etc.
The administrator has disabled public write access.

Formula functions - age 1 month 2 days ago #10572

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
Double tap on the student's name

Screenshot2022-06-02at16.43.56.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

Formula functions - age 1 month 2 days ago #10573

Is it possible to input the birthdates in a column, like an excel list? What is the acceptable format to do this? Thx.
The administrator has disabled public write access.

Formula functions - age 1 month 2 days ago #10575

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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 take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
Time to create page: 0.133 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.