Hello,

I have created an attendance tracker with each month being its own sheet and a Summary sheet that tracks the occurrence (unexcused, no-call no-show, etc.) points accumulated over 6 months. The summary sheet consists of two summaries - one for the first half of the year and another for the second half. What I actually need though is something that generates the occurrence points over a 6 month rolling period with the points falling off after 6 months. The points vary from .5 to 3. I have no idea where to begin with this task and any advice is appreciated.
Attendance Tracker.xlsx