I am in need of an excel program that will generate a monthly shift schedule that will auto complete dates in calendar format.
I will need the shift times/employee initials listed in color code included (see attached excel example)
Details of Info required to be displayed.
shifts will be 9 hours. There will be 3 shifts
times of each shift:
Shift 1: 0600-1500L
Shift 2: 1400L-2300L
shift 3: 2200L-0700L (next day.)
There will be rotating weekend coverage from 0700-2300L
Shift 1 will cover first weekend
Shift 2 will cover second weekend
Mgr will cover 3rd weekend
Shift 3 will not be included in weekend coverage rotation.
Ideally i would like day cells to be large enough to include time and 2 letter initial of employee
ie: 0600-1500L (2 letter initial) // 1400-2300L (2 letter initial) // 2200-0700L (2 letter initial)
every 3 months (based on calendar dates 1 Nov-Feb 1) employee on shift 1 will move to shift two.
Employee on shift two will move to shift 3. Employee on shift three will move to shift one.
Example attached is just for visual aid. Willing to accept different layouts as long as schedule can be auto populated.