Create two day rotating schedule (Weekends) for 7 people (3 shifts on Saturday and 2 shifts on Sunday) NO VBA

mteresi

New Member
Joined
Apr 19, 2018
Messages
1
Looking to create a file in excel that will help me find a rotating schedule for the following:

1. Saturday and Sunday Work Days
2. 3 Shifts (3 Doctors) on Saturday and 2 Shifts (2 Doctors) Sunday.
3. Doctors cannot work both days. (If you work Saturday you are off Sunday and vice versa)
4. Right now it is a 6 doctor schedule but will go to 7 this year so....
5. Would love for the file to allow increase or decrease in doctors as we grow.
6. There will be weeks where a doctor does not work either day of course.


Questions? If anyone can help me create this file i would be super appreciative.

Thank you in advance - MT
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,095,934
Messages
5,447,396
Members
405,450
Latest member
JamesLH

This Week's Hot Topics

Top