Two-variable best scenario for work shifts

[Winnfieldster]

Hi!

First of all, thanks in advance to everyone that saved my sorry a** more times that I can imagine, since I've been visiting this site regularly for tha past 5 years and always found a solution. First time posting, though.

The problem is (or seems to be) fairly simple, I have to design consecutive work shifts for my team, one in the morning (called C1a), and one in the afternoon (called C2) and distribute evenly throughout a sample month of 5 weeks and I came, manually, with this scenario:

TURNS	W1	W2	W3	W4	W5
Teammate 1	C1a	C2	C2	C1a	C2
Teammate 2	C2	C2	C1a	C2	C1a
Teammate 3	C2	C1a	C2	C1a	C2
Teammate 4	C1a	C2	C1a	C2	C2
Teammate 5	C2	C1a	C2	C2	C1a

<tbody>
</tbody>

The conditions for the best scenario are:

• There must always be 3 people in the afternoon shift (C2) and 2 people in the morning shift (C1a)
• People shouldn't work too often (consecutively) in the afternoon shift (it kind of suckt because it ends 11 pm...) so I want them to rotate as often as they can-
• Every teammate should have equal shifts design

My first question is: Is this something that can be achieved through scenarios / what ifs / solver in Excel?

Second one is: Is it a better solution other than my manual attempt?

This might be a theoretical exercise after all, but I'd really love to see some serious excel combinations to validate...

I uploaded an example here...

Many thanks for your help!