Auto-shift weekend dates to a workday

Auto-shift weekend dates to a workday

TL;DR: Whenever a subitem's date or timeline lands on a Saturday or Sunday, automatically shift it to the next workday (or the previous one). Useful when the rest of your date logic spits out weekend deadlines and you want the calendar view to stay clean.

What this does

Recipe: "If subitem's date/timeline changes to occur on a weekend, move it to the next/prior workday."
Whenever any other automation, manual edit, or user action sets a subitem date to a Saturday or Sunday, this recipe immediately re-shifts it to either the next Monday or the previous Friday — your pick. The end result: subitem dates never sit on a weekend.

When to use it

  • You use date-sync or offset date automations and don't want them landing tasks on weekends
  • Your team works strict Monday–Friday hours; weekend due dates create false alarms
  • Calendar views and dashboards should never show weekend deadlines
  • SLA workflows where business days matter (move to next workday) or deadline-day workflows (move to prior workday)

Before you start

  • A Date or Timeline column on the subitem
  • Decide direction — next workday (push forward) or prior workday (pull backward). Most teams use "next" for due dates and "prior" for fixed-deadline rituals (e.g. "review must complete BY this date").

Set it up

    Open Automate → Create on your board.
    Copy the recipe text above and find it in your board's automation center, then click Use Template.
    Configure:
  • Subitem date column — the date that should never land on weekends
  • Direction — next workday (Mon) or prior workday (Fri)
    Click Create automation.

Test that it works

    Set a subitem's date to a Saturday or Sunday.
    Confirm the date immediately shifts to Monday (or Friday, depending on your direction setting).
    Pair-test: trigger an upstream date automation that would normally land on a weekend, and confirm this recipe catches and re-shifts it.

Common gotchas

  • Saturday and Sunday only. The recipe doesn't account for holidays, custom non-working days, or per-region calendars — it strictly operates on weekend days.
  • Fires on every date change. If you set a Saturday date intentionally (rare), it'll be auto-shifted. There's no per-subitem opt-out.
  • Pair with date-sync or offset automations. This recipe is most useful as a "cleanup" layered on top of  date-sync recipes  or  offset-based default dates  — it catches weekend results from those rules.
  • Order of operations. If multiple automations modify the same date, this one fires last (after the upstream change) — so the final value lands on a workday regardless of the upstream logic.
  • Timeline columns shift the start, end, or both? Test with your specific Timeline use case to confirm which boundary moves.

Next up

 Date & timeline automations  (browse the full date library)

Related

  •  Date & timeline automations  (parent landing)
  •  Sync all subitem dates with the parent  (upstream sync — pair these for a clean workday-only chain)
  •  Date + offset — full reference 

Still stuck?

Email  hello@fantasymedia.io  and we'll help you wire up the workday safety net.