2027 Shift Worker Planner

A shift calendar and overtime estimator for rotating-shift workers. Pick your rotation, enter one date you worked, and see your whole 2027: every shift, the days you and your partner are both off, and an estimate of your pay and overtime.

$9.99 launch price · instant digital download

Works in Microsoft Excel and Google Sheets (free Google account). One .xlsx file + a "Start Here" PDF guide.

Full-year 2027 shift calendar colour-coded by day, night and off shifts

What it does

8 rotation options

Pitman 2-2-3, 4-on-4-off, DuPont, 24/48, Kelly, Panama, 5-2 weekdays, plus Custom patterns up to 28 days (Day, Night, Evening, 24-hour, Off). Team offset for A/B/C/D crews.

Overtime checked against state law

Weekly OT, optional daily OT and double time with your own thresholds, or a California preset based on the California Labor Commissioner's overtime FAQ: 1.5x over 8 hours, 2x over 12, and the 7th-consecutive-day rule.

Your workweek, your pay periods

Choose the day your workweek starts and group pay by weekly, biweekly, semi-monthly or monthly pay periods.

Both-off days

Add a partner's rotation and see every day you're both off, counted per month.

Printable months

Full-year calendar plus 12 month pages that each print on one landscape page, with room for notes.

Extras

2027 US federal holidays with your shift on each one, and a night-shift sleep log with monthly averages.

The calculations are tested against the stated rules with 33 automated checks. The calendar is only as right as the start date you enter.

A look inside

Printable January 2027 month page
Printable month pages
Days you and your partner are both off
Both-off days with a partner
Pay and overtime estimate by month
Pay & overtime estimate by month
Pay periods tab
Pay periods: weekly, biweekly, semi-monthly or monthly
Setup tab with yellow input cells
Setup: fill in the yellow cells
Examples of built-in rotations
Built-in rotations

Dollar amounts in the screenshots are example output (Pitman, 7 AM–7 PM, $30/hr, California rule), not a promise of pay.

How it works

  1. Buy and download the file from the link on your receipt page or email.
  2. Open it in Excel, or upload it to Google Drive and choose Open with Google Sheets → File → Save as Google Sheets.
  3. On the Setup tab, fill in the yellow cells: rotation, a date you worked, shift times, hourly rate.
  4. Everything else updates automatically.

Free sample: January 2027

Try before you buy. Printable January 2027 calendars for Pitman 2-2-3, 4-on-4-off, DuPont and 24/48.

Download the free sample (PDF)

FAQ

My rotation isn't listed. Can I still use it?

Yes. Choose Custom and type your pattern, for example D,D,N,N,O,O,O,O (up to 28 days).

My calendar is a few days off from my crew's.

Enter a date that was the first day of your pattern, or change "Team / offset" on Setup.

Do I need Excel?

No. A free Google account and Google Sheets work. Not designed for Apple Numbers.

Does it work on my phone?

You can view and edit it in the Google Sheets or Excel apps. Setup is easiest on a computer.

Is the pay exact?

No. It's an estimate of gross pay from your hours, rate and the overtime rule you pick. It doesn't include taxes, deductions or differentials.

What about states other than California?

Use "Weekly only" (OT after 40 hours a week) or "Daily + weekly (custom)" to set your own daily and double-time thresholds. Only California has a preset.

24-hour shifts?

Yes. 24/48 and Kelly are built in, and you can set the paid hours for a 24-hour shift.

Can I print it?

Yes. Each month prints on one landscape page. In Google Sheets, use File → Print → Fit to page.

Refunds?

It's a digital download, so refunds aren't usually offered, but if the file doesn't work, contact me and I'll help or refund you. See the terms.

Get the 2027 Shift Worker Planner

$9.99 launch price

Please note: Digital download, nothing is shipped. Covers calendar year 2027. Pay and overtime figures are estimates for planning only, not payroll, tax or legal advice. Union contracts, alternative workweek schedules, exemptions and other states' rules can differ. Always confirm with your employer.