So here's what I'm working on.

I'm working on an attendance system that'll add points depending on the incident.

So far I've been able to come up with the calculations to add the points for the month. The last bit I'm having trouble with is subtracting points for perfect attendance.

What I'm trying to do is get excel to subtract 2 points from the running total if there are no occurrences for that month.

Or if there's a way to be able to date the last occurrence and automatically deduct 2 points if there are no attendance issues 30 days thereafter.



FSS Attendance Tracking.xlsx


BTW I am not claiming to have came up with the formula on my own. I found a similar post to this on here and modified the information to fit my needs.

Thanks to the original poster and the people who help him/her.