[Solved] Shift roster in Excel

[ahmadqoqazeh141977]

hello every one
i want to make roster 4 days day shift & 2 days off after that 4 days night shift & 2 days off
if any one send me the formula

 

[shamimarita]

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:

• How to Create Shift Roster 24×7 with Excel Automation
• How to Create an Automatic Schedule Generator in Excel (Easy Steps)
• How to Create Monthly Duty Roster Format in Excel
• How to Create an Attendance Roster in Excel (with Easy Steps)
• How to Create Weekly Duty Roster Format in Excel