I have people and each of them get to pick what two days a week they want. For each day I have a set number of days off. The problem I want to avoid is ending up with 2 of the same day as off days for 1 person. I would hope there would be several options to figure this. I would like to use a formula or vba that would either force them to pick a particular day off at some point or stop or warn me at a point, that if I continue I will end up with 2 of the same day as off days. As an example:
I have 168 people, they can pick from these set number
Mondays 95 days-off
Tueday 34 days-off
Wednesday 33 days-off
Thursday 33 days-off
Friday 33 days-off
Saturday 66 days-off
As of now I do a manual count at a certian point, and repeat this several times just not to end up with the problem I described above. Can someone please help?
I have 168 people, they can pick from these set number
Mondays 95 days-off
Tueday 34 days-off
Wednesday 33 days-off
Thursday 33 days-off
Friday 33 days-off
Saturday 66 days-off
As of now I do a manual count at a certian point, and repeat this several times just not to end up with the problem I described above. Can someone please help?