Employee Attendance on Rolling 6 Months

Good morning,

I am new to the group as well as the Excel System. I am trying to come up with a spreadsheet that will track our employees attendance on a 6 month rolling attendance calendar. I am having a hard time getting the attendance points to roll off after 6 months. I'm tracking attendance by day, week and month. If an employee has perfect attendance for 30 straight days, then a specific value is entered in that month. What formatting can I use to highlight cells as long as an employee has perfect attendance? Example, perfect attendance in May, June, July all 3 months will be highlighted. If August is NOT a perfect attendance month, then prior months will no longer be highlighted. Also if they have perfect attendance for 30 straight days, the OLDEST point will fall off. Is there a formula I can use to make this happen? I want to set it up so that perfect attendance is noted by a trophy symbol (% in Webdings). How do I set the formatting so that it highlights all cells with that symbol, and then if a month is missed, then all prior highlights go away?

I hope I am not trying to do too much :-). I need to be able to show each agent there progress at will without showing them all the other agents history. Any suggestions on how to do this? Attached are copies of the first two weeks of data since we've been tracking this information. Any help would be great!!!!