Thread: Schedules and consecutive days off work

Hello guys,
I hope someone can help me out with this.
I worked with schedules, I created a report that counts the amount of days off per week an agent has an also checks if they have at least more than 12 hours between shifts. Now I want to add the possibility to see if excel can check if they are not working more than 6 days in a row between 2 weeks.
Things you might need to know, the schedules are exported from IEX into a notepad, I already used some left formulas and vlookups to split the info, so I have the starting time in one cell and the end shift next to it, also I have OFF (as per day off) per cell, so every 2 cells belong to one day of information, I'm going to use "|" to show how the schedules look on excel per cell as an example for a person working 9:00am - 5:30 with Tuesday and Thursday OFF in one week and OFF on the next week on friday and saturday:

Agent X
Week 1
Monday Tuesday Wednes Thursday Friday Saturday Sunday
|09:00|05:00|OFF|OFF|09:00|05:00|OFF|OFF|09:00|05:00|09:00|05:00|09:00|05:00|

Week 2
Monday Tuesday Wednes Thursday Friday Saturday Sunday
|09:00|05:00|09:00|05:00|09:00|05:00|09:00|05:00|OFF|OFF|OFF|OFF|09:00|05:00|

Both weeks and on the same row, I split it over here because of the lack of space
So is there a way excel can count and tell me if this agent 'X' is working more than 6 consecutive days in a 2 weeks time period???
I'm using excel 2007

Thanks for the help and sorry for the mess of information

Cheers,