SRRD

Date & Time

Shift Rotation Recurring Date Calculator

Generate recurring work-block dates and calculate cycle length, final start, scheduled and net workdays, scheduled hours, calendar span, and horizon difference.

Complete rotation length-
Days from start to final listed work block-
Final listed work-block start date-
Scheduled workdays across listed blocks-
Workdays after entered leave-
Hours after entered leave-
Calendar span through final work block-
Schedule span minus entered comparison-

Decision view

Recurring shift-cycle Gantt and horizon marker

Recurring shift-cycle Gantt and horizon markerWork and off blocks repeat on an exact calendar-day scale with final-block and comparison-horizon markers.
Exact scenario comparisonWork-block starts to list changes while all other entered assumptions remain constant.
Work-block starts to listComplete rotation lengthDays from start to final listed work blockFinal listed work-block start dateScheduled workdays across listed blocksWorkdays after entered leaveHours after entered leaveCalendar span through final work blockSchedule span minus entered comparison

Period-by-period detail

Recurring work-block start dates

Each row advances by one complete work-off cycle and preserves scheduled workdays and hours.

How to use Shift Rotation Recurring Date Calculator

  1. Enter the first work-block date.
  2. Enter consecutive work days, off days, and number of starts.
  3. Enter shift hours, planned leave, and comparison horizon.
  4. Review the recurring-date table and cycle Gantt.

Calculator guide

Understanding Shift Rotation Recurring Date Calculator

A repeating shift rotation is a calendar cycle, not a monthly recurrence. Every new work block begins after the exact work-day plus off-day cycle, so dates, workdays, leave, and hours must share one consistent sequence.

Cycle drives dates Not calendar months.
First offset is zero Twelve starts mean eleven gaps.
Leave affects work Not the recurrence.
Span includes final block Four more days follow its start.

Calculation method

How the calculation works

Project the shift rotation from its entered start date and work-off cycle, listing each work-block start while retaining leave, hours, and calendar-span totals. Add work and off days to form the cycle, advance the start date by whole-cycle offsets, then multiply workdays by occurrences and subtract entered leave.

Detailed calculation process

Repeat a work-off cycle across calendar dates

The default rotation starts July 22, 2026, repeats four workdays and four off days, lists 12 work-block starts, and removes two planned leave workdays.

General formula: c = w+od_k = (k-1)cD_k = D_0+d_kd_last = (K-1)cW_s = wKW_n = max(W_s-L,0)H = W_nhspan = d_last+w One cycle is the sum of consecutive work and off days. Each listed block start advances by an integer number of cycles; work quantities are accumulated separately and leave is removed before hours.

What each symbol means

D_0, D_k First and kth work-block start dates.
w, o, c Work days, off days, and complete cycle days.
K, k Number of listed starts and block index.
d_k, d_last Calendar-day offsets from the first start.
W_s, L, W_n Scheduled workdays, leave workdays, and net workdays.
h, H Hours per shift and total scheduled hours.
span Calendar days through the final work block.

Worked substitution with the default inputs

1. Build one cycle c = 4+4 = 8 calendar days Every work-block start is eight days after the prior start.
2. Locate the final start d_last = (12-1)(8) = 88 daysJuly 22, 2026 + 88 days = October 18, 2026 The first occurrence has offset zero, so 12 starts contain 11 intervals.
3. Count scheduled workdays W_s = 4(12) = 48 workdaysW_n = max(48-2,0) = 46 Entered leave is deducted from scheduled workdays, not calendar days.
4. Calculate work hours H = 46(12) = 552 h Each net workday uses the entered 12-hour shift length.
5. Reconcile calendar span span = 88+4 = 92 dayshorizon difference = 92-90 = 2 days The span includes the four-day final work block and exceeds the comparison horizon by two days.

The 12 listed blocks span 92 calendar days through the final work block, contain 46 net workdays after leave, and total 552 scheduled hours.

Recurring roster timeline

See work and off blocks repeat on one Gantt scale

Alternating work and off bands mark all 12 cycles, with the first and final dates, leave-adjusted work total, and comparison horizon labeled.

Work bands Four-day active blocks.
Off bands Four-day recovery blocks.
Date anchors First and final starts.
Horizon marker Entered comparison day.

Worked situations

Practical examples

  • A 4-on/4-off rotation repeats every eight days.
  • The 12th block starts October 18, 2026.
  • Two leave workdays reduce 48 scheduled days to 46.

Better inputs

Useful tips

  • Anchor the start date to a confirmed roster block.
  • Add exceptions outside the repeating model.
  • Check daylight-saving and payroll rules separately.

Before relying on the result

Limitations and common mistakes

  • The model assumes an uninterrupted repeating cycle.
  • Roster swaps, holidays, partial shifts, labor agreements, and payroll weeks are excluded.
  • Hours are quantities and do not model clock-time daylight-saving changes.

Reference

Key terms

Work block
Consecutive entered workdays beginning on a listed date.
Cycle
Work days plus off days.
Occurrence
One work-block start.
Calendar span
Days from first start through the final work block.

Important note

Calculated directly from the entered values using the displayed formula and rounding settings.

Frequently asked questions

Why is the last start 88 days later?

Twelve starts contain eleven eight-day intervals.

Does leave shift future block dates?

No. It reduces workday and hour totals only.

Why is the span 92 days?

It adds the four-day final work block to the 88-day start offset.

Does this handle daylight-saving time?

No. It treats dates and entered shift hours as planning quantities.