Hello. I found an attendance tracker online that I'm planning to present for use to my supervisors, and I've edited it to do what we need wonderfully. The only issue is that our attendance points here roll off after 6 months and the way this thing is set up I'm having a heck of a time getting it to calculate that properly.
Ideally excel would identify which day to roll stuff off, but I felt like that'd be a ton of formula entry for each day on the calendar, so I resorted to just being ok with the month to month roll off (meaning if an employee had 6 points in April, those'd reflect as falling off October 1st, regardless of the actual date in April they were accrued).
I've tried fiddling with the formulas for 2 days now and I can't get anything past October to reflect correctly (and as a result I'm paranoid that anything from July on isn't showing properly even though it looks right so far). Was hoping to get some insight into where I'm going wrong or how to do this easily? I tried having the 'total' cell add all the days from that month, then add the previous 5 months and then subtract anything before that but it's just not working properly.
So I'm looking for advice from the month of July onward (my demo sheet is attached so this makes more sense when looking at it).
Thanks!
BONUS: Is there any way to have a separate tab on a sheet that compiles all notes entered? Right now I'm right-clicking attendance issues to leave notes about the absence or tardy, but in the event those'd need to be printed out, having them compiled somewhere would make life easier. Just a thought, way more concerned about the first part to be honest.
Bookmarks