Hello guys and girls,

Just registered here, I'm assuming this is the best place to get excel answers!

This is what I need excel to do for me.. I have about 40 employees, all with various availabilities. At our work we have two shifts, A and B, first being from 1030-330 and the other 330-to close. Each person can have less than or equal to 5 shifts per week. Is there any way I could create a template that will do the scheduling for me? Any other suggestions on how to approach this? Thank you in advance.

Brian