Rotating Shift Planner

Built for people who don't work 9 to 5. Pick your rotation, enter a date your cycle started, and this Excel and Google Sheets planner fills in your whole year, color coded: every day, night, 24-hour shift and day off. Then it tells you your next day off, your next full weekend off and which holidays you're working.

What You Get

• Rotating Shift Planner spreadsheet (.xlsx) for Excel 2010 or newer and Google Sheets
• Bonus 7-page fillable + printable PDF: monthly shift calendar, rotation planner, sleep & recovery plan, shift meal planner, family & life sync, swap & overtime log, days-off planner (US Letter)

12 ROTATIONS BUILT IN

DuPont, 2-2-3 Panama (rotating), 2-2-3 Pitman (fixed days or nights), 4 on 4 off (days or rotating), 3 on 3 off rotating, 24/48, 48/96, Kelly schedule, 5 on 2 off, 4-3 rotating (10-hr), plus your own custom pattern.

Spreadsheet Features

• Any year: type the year and every date, U.S. holiday and calendar updates
• One-page color-coded year calendar, ready to print
• Dashboard: today and tomorrow, next 14 days, next day off, next full weekend off
• Month by month: day, night, 24-hour, off, vacation and overtime counts, hours worked and weekend days off, plus a chart
• Changes tab for vacation, swaps, overtime, training and sick days; each replaces your pattern that day
• Holidays tab shows which holidays you're working; add birthdays and family events too
• Set your own hours per shift type

Perfect For

Nurses and CNAs, firefighters and EMS, police and dispatch, plant and refinery operators, maintenance techs, security, and their families. A thoughtful gift for a new shift worker.

How It Works

1. Purchase and download from Etsy (Purchases > Download files).

2. Open the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets.

3. On the Setup tab, choose your pattern and enter a cycle start date. Compare the first two weeks with your real schedule.

Please Note

• This is a digital download. No physical item will be shipped.
• Requires Excel 2010 or newer, or a free Google account. Not tested in Apple Numbers.
• Holidays shown are U.S. holidays. The sleep page is a planning tool, not medical advice.
• For personal use only. Not for resale or redistribution.

[Optional, if you used AI tools in creating this listing:]

Created by me with the help of digital and AI-assisted design tools; every page and formula was reviewed and tested.

------------------------------------------------------------

NOTES (do not paste)

Timing: list before December. Shift workers look for next year's calendar in November-January.

The file ships set to 2027 with DuPont and sample changes; the listing screenshots show a 2026 copy so the dashboard displays today's values.