Rolling 6 month Attendance Tracker

I am struggling hot to tie in all the moving parts of my excel spreadsheet. I created it by myself and may need to reformat a few things.
I have attached the sheet.
Some background.
Our attendance points last for 6 months (181 days)
the abbreviation key i made allows the tracking of all the different types of absences. Some of them do not count as an attendance point.

Absent "A"= 1 point
Consecutive Absence "C"- 0 points
1A- Report of Foodborne Illness "F"= 0 points
No Call/No Show "N"= 1 point
Tardy "T"= 0.5 points
Leave of Absence "L"= 0 points
Emergency Excused "E"= 0 points
Improper Call Out "I"= 1 point
Doctor's Note "D"= 0 points

I am trying to figure out how to tell the document to track any of the "Occurences" that have points attached to them to a seperate part of the page. I highlighted that area in Dark green and labeled it "Active Points".
Is there a way to bring over any trackable absences to that area. Only ones that have happened in the last 181 days? Once it has been 6 months then it automatically removes it?

I also made a little occurrence counter next to January that calculated how many different types of absences happened but it tracks them all as a whole and not what the employee is being held to.
In case it was needed i added "Roll Off Dates" to every day to show when any points would fall off but still want them pulled to a single location instead of making people go through and manually count every time.



I hope that makes sense!