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:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]TURNS[/TD]
[TD]W1[/TD]
[TD]W2[/TD]
[TD]W3[/TD]
[TD]W4[/TD]
[TD]W5[/TD]
[/TR]
[TR]
[TD]Teammate 1[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD]Teammate 2[/TD]
[TD]C2[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[/TR]
[TR]
[TD]Teammate 3[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD]Teammate 4[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD]Teammate 5[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[TD]C2[/TD]
[TD]C2[/TD]
[TD]C1a[/TD]
[/TR]
</tbody>[/TABLE]

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!