[Solved] Shift roster in Excel

Hello,

To set up the full schedule, you can create a repeating shift pattern using Excel’s MOD() and IF() functions.
You can use =MOD(ROW(A1)-1,6) to cycle through numbers 0-5.
Apply IF() to assign shifts:
Day shift: =IF(MOD(ROW(A1)-1,6)<4,"Day","Off")
Night shift: =IF(MOD(ROW(A1)-1,6)=4,"Night","Off")
You can then copy this formula down for each employee.

You can explore the following articles to customize your roaster sheet:
 

Online statistics

Members online
0
Guests online
23
Total visitors
23

Forum statistics

Threads
371
Messages
1,623
Members
704
Latest member
Michael Mpofu
Back
Top