I have a point system at work where if your late 1 point. Gone the entire day 2 points. After 20 points your gone. Points come off a year later from the day it was assigned per the previous year. Does anyone have a spreadsheet already configured where each day the employee's total point are auto tabulated, where it goes back 365 days from the current date and reverses them back, with a new year to date total. Sounds complicated but I think anyone that has a point system that reverses points back on a rolling one year basis knows what I'm looking for.