I work in a school and attendance is something we wish to focus upon. I would like to be able to calculate the following:
If a student's attendance falls below 90%, I would like to calculate in Excel how many days of full attendance would be needed to take that student's attendance back to 90%.
For example:
There are 2 sessions per day.
Possible Attendance = 140
Actual Attendance = 122
Percentage Attendance = 87.1
To get back to at least 90% attendance the student will need to fully attend the next 20 days to get back to 90%.
Possible Attendance= 180
Actual Attendance = 162
Percentage Attendance = 90
(180-140)/2 = 20 School Days
Is there a way to get the number of days needed?
I would also need to factor in week-ends and school holidays. Any guidance pointers would be gratefully received.