Adjust attendance tracker to treat consecutive absences as a single.

So our attendance policy states "If you are absent consecutive days, it’s considered one (1) incident."

My current tracker is just a SUMPRODUCT. So i need to adjust the Unscheduled Absence (UA) so that if an UA appears next to each other, that no more than one is counted.

Does that make sense?

You can try this for D6

Formula:

Please Login or Register  to view this content.

copy down

Loving it! Thank you!