A preparation deadline is often easier to calculate from the celebration date backward. Decide whether your lead time means calendar days before entering an offset.
For an event on January 3, 2027, choose Custom Milestone, enter 14, and select Before starting date. The target is December 20, 2026. The calculation crosses the year boundary without changing the length of the lead time.
Turn the result into an action
Save December 20 as a one-time date titled “Confirm celebration booking.” Keep January 3 as the event date. If the event moves, recalculate the preparation deadline and edit that record separately.
The offset excludes the starting date as an elapsed interval. Fourteen days before January 3 means the difference from December 20 to January 3 is fourteen days.
Check the kind of deadline
This tool counts weekends and holidays. A supplier asking for fourteen business days may require an earlier date. Confirm its definition and opening hours before relying on a booking deadline.
A target in the past shows zero remaining days and Completed Milestone as Yes. That indicates the date has arrived or passed. It cannot confirm that you actually completed the task. Record task completion in a celebration plan.