Date & Time
Timesheet Recurring Date Calculator
Generate recurring timesheet work dates with preserved cadence, weekend movement, blackout events, review points, and weekly workload density.
Recurrence calendar heatmap
Occurrence rhythm, weekend moves, blackouts, review markers, and weekly workload density
The calendar preserves each nominal recurrence date, then visibly marks operational adjustments instead of silently shifting the whole series.
Occurrence register
Recurring timesheet occurrence ledger
Review nominal day, adjusted day, weekday, paid hours, blackout status, and supervisor-review marker for every occurrence.
| Occurrence | Nominal day | Adjusted day | Weekday | Paid hours | Adjustment | Review |
|---|
How to create the series
Define recurrence before applying exceptions
- Choose the first weekday and interval.
- Enter the number of planned occurrences.
- Set paid hours per active occurrence.
- Choose whether weekend events move to Monday.
- Add blackout and review cadence only when they are real controls.
Recurrence logic
An adjusted occurrence should not shift the underlying cadence
The schedule calculates every nominal date from the original anchor. This prevents a weekend move from turning a weekly Wednesday series into a permanent Thursday series.
Blackout occurrences remain in the audit register with zero hours, which explains gaps without hiding the planned event.
Calculation method
Generate nominal recurrence dates before applying local weekend and blackout rules
Each nominal occurrence is computed from the original series so one adjustment does not drift every later date. Weekend moves and blackout skips are then applied per occurrence.
Detailed calculation process and general formulas
d_n=d_0+(n-1)kd_adj=nextMonday(d_n) when policy appliesH_total=sum(H_n for active occurrences)Reviews=floor(N/r)Density=active_weeks/total_weeksSymbols, meanings, and units
- d_n
- nominal day offset for occurrence ncalendar days
- k
- recurrence intervaldays
- H_n
- paid hours assigned to occurrence nhours
- N
- number of nominal occurrencesoccurrences
- r
- occurrences per supervisor reviewoccurrences/review
Cadence diagnostics
What the calendar reveals beyond a date list
The heatmap makes density, exception clustering, review placement, and weekend pressure visible.
Total paid effort
—Hours assigned to active recurring events.
Weekend pressure
—Occurrences moved from weekend to Monday.
Blackout gaps
—Scheduled occurrences retained but assigned no hours.
Weekly density
—Share of schedule weeks containing active work.
Decision takeaway: Keep nominal and adjusted dates together; otherwise schedule exceptions become invisible drift.
Recurrence checks
Inspect exception rules before publishing dates
- Weekend policy may differ by team.
- Blackouts can collide with review points.
- Moved events can create same-day duplicates.
- Paid-hour totals should exclude cancelled occurrences.
Schedule evidence
Records that preserve the recurrence trail
- Original recurrence rule
- Weekend adjustment policy
- Blackout approval log
- Supervisor review calendar
- Final occurrence register
Practical applications
Decisions this calculator is designed to support
Weekly timekeeping audit
A reviewer samples a fixed block of timesheet work every week with periodic supervisor sign-off.
What the result clarifies: The calendar shows moved weekends and retained review cadence.
Recurring payroll correction window
A correction session repeats every ten days but every fifth event is blocked by a close cycle.
What the result clarifies: Blackouts remain visible without shifting later nominal dates.
Worked example
Current-input substitution and reconciliation
Model limitations
This relative-day scheduler does not use a civil calendar or holiday database. It models weekday movement and recurrence rhythm but not month length, daylight-saving changes, named dates, employee leave, or duplicate-event conflict resolution.
Timesheet Recurring Date Calculator FAQ
Does moving one event shift later events?
No. Every nominal date is calculated from the original anchor.
Are blackout hours included?
No. Blackout occurrences remain listed with zero paid hours.
What does weekend policy 1 do?
It moves Saturday and Sunday occurrences to the following Monday.
Can reviews fall on blackouts?
Yes; the register shows both conditions so the review can be rescheduled deliberately.