Attendance Tracker

Hi everyone,

I have been tasked with coming up with an attendance tracker at work. I have been messing with it for a while now and I have been surfing the web for answers. I have found a lot of things that are similar, but I can't quite adapt them to what I want to do.

So, we award 1/3 of a point for a tardy and 1 point for an absence.

The Tardy/Absence criteria will pull from another spreadsheet.

I used a countif to determine the number of points based on Tardy/Absent.

I am now trying to create a rolling 90 day total and a rolling 365 day total. So I will pull up the file, add a new column that will pull the previous day's Absences/Tardies and then have my 90/365 day period update to reflect the new date.

I have been messing around with OFFSET and EDATE, which are new to me. If anyone can help me come up with a formula to figure this out, I would be ecstatic! It would be even better if you could explain how it was done as well so I can learn. Thanks!

~B