Day shift for X months, then Night shift for Y months I created the Rotation_Advanced worksheet specifically for cases like this, where the repeating pattern is '11xxx11xx111xx' with 'x' meaning OFF and the '1' meaning ON. Some rotation schedules use a pattern that repeats every fortnight (2 weeks), and may be referred to as 2/3/2. If using the String method, this would be defined as '12xx'. In some cases, an employee might work 2 days on Shift 1, followed by 2 days on Shift 2, followed by a number of days off.Īn example would be a 4-day shift pattern in which an employee works a 12 hour day shift the first day, followed by a 12 hour night shift the second day, followed by two days off. Or, if using the String method, you can define a 4/2 pattern as '1111xx'. Shifts that involve working X days followed by Y days off are easy to handle with this rota template. But, it does a pretty good job of handling most of the common cases: Patterns

This rotation schedule template does not handle all types of shift schedule patterns. The workbook contains a 'Holidays' worksheet where you can list days that should be considered non-working days. In these worksheets, the rotation excludes both weekend days and holidays, all of which we call 'non-working days.' This means that if the rotation calls for you to work 2 days starting on Friday, then you would work Friday and then Monday (skipping the non-working weekend days). In the Rotation_String worksheet, you can define a rotation as a repeating string such as '11xxx22xx333xx' which would mean that you work Shift 1 for 2 days, followed by 3 days off, followed by working Shift 2 for 2 days, followed by 2 days off, followed by working Shift 3 for 3 days, followed by 2 days off.īoth the Rotation_Advanced and Rotation_String worksheets use the new built-in function NETWORKDAYS.INTL(), available as of Excel 2010, to let you choose which days make up the 'weekend' (Sat/Sun, Mon/Tue, Sunday only, etc.) and to also account for holidays.

For a simpler 'days on/off' pattern, just leave the 'Shift 2' field blank.

In the first two worksheets ( Rotation and Rotation_Advanced), the rota schedule is defined by entering the numbers of days on Shift 1, followed by the number of days on Shift 2, followed by the number of days off. The workbook contains 3 separate worksheets, each providing a slightly different set of features. Just enter the year and start month, then use the other inputs to define your shift schedule pattern. This template provides a convenient way to display your work rotation schedule, using the annual calendar template as a basis.

Weekly work schedule template excel