iDoceo - Teacher gradebook and planner app for iPad in App Store - iDoceo forum - Topic: Formula functions

Welcome, Guest

TOPIC: Formula functions - age

Formula functions - age 1 month 2 days ago #10569

rafiei71 OFFLINE New member Posts: 3	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
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

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

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

rafiei71 OFFLINE New member Posts: 3	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 OFFLINE Admin Posts: 3485 Thank you received: 686	Double tap on the student's name
	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

rafiei71 OFFLINE New member Posts: 3	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 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.

Forum

iDoceo forum

Calculations

Formula functions - age

iDoceo 8 for iPhone,iPad and Mac now available!