Calendar Pattern Recognition

I have come up dry from multiple communities in finding a solution to my shift schedule problem.

So here is what I want to do. Currently I am on a changing schedule where I am on 7 days, then off 4, then work 4, then off 4, on 1, then on 4, then on 7. The days I am off, my colleague is working the other nights, and on the same schedule.

So for a visual. Lets take this shift period as an example. I started on Thursday the 3rd last week, and my week will end on the 9th. Then I work again Sunday the 13th to Wednesday the 16th. After that, I do not work till Sunday the 20th. Next is Thursday 24th to 27th. (Before the 24th is my co-worker's 7 day) Next shift is another 7 day Thursday the 31st to Jan the 6th. So is it possible to program a calendar for my changing shift, or should I get times where it changes every two months instead?

That's a crazy schedule.

But if it's a regular algorthim you can implement it in excel or other spreadsheet software (like google doc sheets to be able to view it online, from say a mobile phone). Or did you need something more complicated?

It would look something like this. Note: I get confused easily so you'd need to work on the actual algorithm yourself.

Use the fill handle (little black square on the bottom-right of the highlighted cell) to extend the dates and just copy/paste the On/Off dates further down after making sure they fit a regular cycle and match the correct dates you'd be on and off.

Whoa! It might be possible for me to implement then. The one change that would be need to be accounted for, I guess is the fact I work 1-9 Sunday as second shift for twice. So this coming 13th and 20th. You did this brilliantly though, I have crap experience with Excel. Technically the pay period is Monday to Sunday, but the way you have it laid out could work. I want to take that, and export it into an actual calendar app. I'm not positive if that is possible though.