Hi all. The teachers who are the users of the attached code, courtesy of this Forum, have been happily using it for more than a year. Now, they are requesting for enhancements as follows:
1. That "Sick" be added to differentiate it from an attendance record that is just plain truant absent. "Sick" should be colored green.
2. In the totals column (Col AC), Sick should be treated as absent for half day (.5) or whole day (1).
3. In AH92 and AI92, the total incidence of at least 5 consecutive absences should now include in the formula the count of at least 5 consecutive absences due to illness.
4. After the update, the diagonal lines should be invisible for a neater look.
This is a repost but number 3 and 4 are added.
Thank you.

Attached Files

FORM.SY 2019-2020 - Copy.xlsm (297.5 KB, 7 views)