Attendance tracker - Calculating total occurrences of absence/tardies. Perfect attendance point reduction

[Formulation]

Currently everything is working as intended except for one feature, the 90 day perfect attendance reward.
Weekends are excluded from the dates in row 5 so anytime I refer to 90 days it's 65 cells. (not perfect but it works for our use)

I set up a situation in the attachment that shows the problem. In row 6, they receive a call off (CO) on 1/3/2017 (1 point)
Then they have two 90 day periods of blank cells. Followed by a call off on 8/15/2017.
This should result in 1 point instead of 2 points.

1/3/2017 = 1 point First 90 day period of blank cells = 0 points Now that employee has 0 points, the second 90 day blank cell period should be ignored as they can't go below 0. 8/15/2017 call off should bring total back to 1 point.
*other rules in place already... Any cells with a drop down selection before their date of hire are ignored.
If they have 0 points and then five 90 day (65 blank cells) perfect attendance periods in a row, then a call off, the total should be 1 point

For every 90 calendar days (65 horizontal blank cells) of perfect attendance = One point will be removed from the total points column for each person.
*However, if an employee's total points are at 0 at any given time, blank cells(perfect attendance) should be ignored. 0 points is the minimum.

Rolling 365 day point drop off period (working) (Uses cell ADO:6)
Points only count on or past the date of hire (working) (Cell ADN:6)
Each cell has a drop down with selections for tardy (TD), call off (CO), Leave Early (LE), Continuous Absence (CA).
TD = .5 Points |||| CO = 1 Point |||| LE/CA can be ignored (0 points)

Cell E6

=COUNTIFS($K6:$ADL6, "CO",$K$5:$ADL$5,">"&(TODAY()-365))

Cell F6

=COUNTIFS($K6:$ADL6, "TD",$K$5:$ADL$5,">"&(TODAY()-365))/2

Cell G6

=COUNTIFS($K6:$ADL6, "LE",$K$5:$ADL$5,">"&(TODAY()-365))

This cell only accounts for how many times "LE" is selecting in a drop down. It doesn't need to be added to the total in column I
Cell H6

=SUM(INT(FREQUENCY(IF(INDIRECT(ADN6&":"&ADO6)="",COLUMN(INDIRECT(ADN6&":"&ADO6))),IF(INDIRECT(ADN6&":"&ADO6)<>"",COLUMN(INDIRECT(ADN6&":"&ADO6))))/65))

This cell adds up the total 65 cell perfect attendance periods. It ignores dates before the hire date, dates 365+ days in the past, and days in the future.
Cell I6

=MAX(0,E6+F6-H6)

totals points
Cell ADN6

=ADDRESS(ROW(),MAX(10,IFERROR(MATCH(TODAY()-365,A$5:ADL$5,0),FALSE),IFERROR(MATCH(A6,A$5:ADL$5,0),FALSE)))

Formula to find first date (hire date of employee)
ADO6

=ADDRESS(ROW(),MATCH(E$3,A$5:ADL$5,0))

Formula to find current date.

 

[Formulation]

Here's a link to sample data. Macro is disabled. http://www.filehosting.org/<wbr>file/details/695981/Copy%20of%<wbr>20Legrand%20Attendance99999.<wbr>xlsm
Anyone have a hint on how I should tackle this to find a solution?