Hi Guys,

I have a row of data that I am looking at for a roster. I want to count the number of times an employee has two days off in a row over a 28 day period.

The rest days are referred to as "X" so realistically I am trying to count the occurrences where X appears twice in a row, 3 times in a row and also where it appears with no X the day before or the day after, so where the rest days are split.

Once i have this sorted my aim would then to be to count the number of times an employee has worked 5 days on and then 2 rest days. I imagine once i get the solution to the above, that will then follow through.

Any help would be appreciated.

Thanks!