TRD

Date & Time

Timesheet Recurring Date Calculator

Generate recurring timesheet work dates with preserved cadence, weekend movement, blackout events, review points, and weekly workload density.

Total recurring paid hours
Schedule span
Weekend adjustments
Blackout occurrences skipped
Supervisor review points
Average weekly hours
Final occurrence day
Active-week 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 rhythm, weekend moves, blackouts, review markers, and weekly workload density Updates with every input

Occurrence register

Recurring timesheet occurrence ledger

Review nominal day, adjusted day, weekday, paid hours, blackout status, and supervisor-review marker for every occurrence.

Live analysis based on the current calculator inputs
OccurrenceNominal dayAdjusted dayWeekdayPaid hoursAdjustmentReview

How to create the series

Define recurrence before applying exceptions

  1. Choose the first weekday and interval.
  2. Enter the number of planned occurrences.
  3. Set paid hours per active occurrence.
  4. Choose whether weekend events move to Monday.
  5. 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_weeks

Symbols, 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.