Attendance Tracking formula

[frostym54]

We have an attendance tracking spreadsheet that is flawed and I am not sure how to fix. On the sheet we input the dates of Occurrences and their value. Either .5 or 1. Disciplinary actions are required whenever the individual gets 3 points in a 30 day period, 6 points in a 90 day period or 9 points in a 180 day period. The issue is that when the first date is entered it calculates the 30, 90 and 180 period from that date. So if a person gets 1 point on 1/3 and another on 1/8, and then skips and doesn't get a point until 2/4 and two one more on 2/6 and 2/7 it does not record the 3 in 30 days.

=IF($J13<=30,IF($E13<=3.5,IF($E13=3.5,3,$E13),"-"),"-")

Employee Name: Message Window
Date of First Occurrence 1st Occurrence + 30 Days 1st Occurrence + 90 Days 1st Occurrence + 180 Days 1st Occurrence + 365 Days
5-Nov-15 5-Dec-15 3-Feb-16 3-May-16 4-Nov-16

Day of Week Mondays Tuesdays Wednesdays Thursdays Fridays Saturdays Sundays
Totals: 1 0 0 1 0 0 2

Sequence Dates Occurrence's (0.5 or 1.0) Total Occurrences 30 Days 90 Days 180 Days 365 Days Days Day of Week
1 05-Nov-15 1.0 1.0 1.0 1.0 1.0 1.0 0 Thursday
2 08-Nov-15 1.0 2.0 2.0 2.0 2.0 2.0 3 Sunday
3 06-Dec-15 1.0 3.0 - 3.0 3.0 3.0 31 Sunday
4 07-Dec-15 1.0 4.0 - 4.0 4.0 4.0 32 Monday
5 - - - - -
6 - - - - -
7 - - - - -
8 - - - - -
9 - - - - -
10 - - - - -
11 - - - - -
12 - - - - -
13 - - - - -
14 - - - - -
15 - - - - -
16 - - - - -
17 - - - - -
18 - - - - -
19 - - - - -
20 - - - - -
21 - - - - -
22 - - - - -
23 - - - - -
24 - - - - -
Instructions: Enter Dates of Occurrences and Occurrence amount (0.5 or 1.0) starting in Cells C7 & D7
Total Occurrences and Discipline targets will be highlighted in RED when targets are met.
30, 90 & 180 & 365 Day Targets will be automatically calculated from 1st occurrence. ;
Tan Cells are the only ones that need to be filled out.