Beyond Native Date Automations: Setting Dates Relative to Other Columns (Deadline = Start Date + N Days)

Monday.com's native automations can set a status, send an email, or create a subitem—but they cannot set a deadline that equals your start date plus 10 days. This limitation affects every organization using monday.com for project management, where relative date calculations are fundamental to scheduling workflows.

You can calculate ADD_DAYS({Start Date}, 10) in a formula column, but that calculated result cannot trigger automations or be automatically copied to an editable date column. This creates a gap between monday.com's powerful calculation capabilities and its automation system, forcing teams into complex workarounds or manual date management.

Why Monday.com Native Automations Fall Short for Relative Dates

Native monday.com automations excel at responding to changes—when a status changes, when an item is created, when a date arrives. However, they cannot perform calculations during the automation process. You can set a date column to "today" or "today plus 5 days," but you cannot set it to "start date plus project duration" or "milestone date minus 10 working days."

This creates several pain points:

Formula columns calculate but cannot trigger: Your formula can calculate the perfect deadline using ADD_DAYS({Start Date}, {Duration}), but when that calculated date arrives, it cannot trigger a reminder automation because formula columns are not available as automation triggers.

Timeline columns require manual dates: Project timelines cannot automatically calculate their end dates based on start dates plus duration columns. Teams must manually adjust timeline spans whenever project parameters change.

Subitem dates cannot inherit relative calculations: When creating subitems through automation, you cannot set their due dates relative to the parent item's dates. Each subitem gets the same fixed due date regardless of when the parent project actually starts.

Cross-board date dependencies break down: If Board A's completion date should set Board B's start date plus 3 days, there's no native automation path to maintain this relationship dynamically.

This limitation is particularly frustrating because the underlying date arithmetic functions exist—ADD_DAYS(), SUBTRACT_DAYS(), and WORKDAY() all work perfectly in formula columns. The gap is in connecting calculated results to automation triggers and actions.

How to Calculate Relative Dates with Formula Columns

The most straightforward workaround starts with monday.com's formula columns, which support sophisticated date calculations:

Basic relative dates: Use ADD_DAYS({Start Date}, 15) to calculate a deadline 15 days after the start date. The SUBTRACT_DAYS() function works similarly for reverse calculations.

Working days only: Use WORKDAY({Start Date}, 10) to add 10 business days, automatically excluding weekends. This is crucial for realistic deadline calculations in business contexts.

Dynamic durations: Combine date columns with number columns: ADD_DAYS({Project Start}, {Duration Days}) creates a calculated end date that updates whenever either the start date or duration changes.

Today-relative calculations: Use DAYS({Due Date}, TODAY()) to show how many days remain until a deadline, or ADD_DAYS(TODAY(), 30) for dates 30 days from now.

However, formula columns hit a wall when you need to act on calculated dates. You cannot trigger an automation when a formula-calculated date arrives, and you cannot use formula results in automated emails or notifications. This is where the workarounds become necessary.

Workaround A: Copy Formula Results to Editable Columns

The most reliable approach combines formula columns with the Community Cookbook "Copy Formula Result to Column" action. Set up a formula column to calculate your relative date, then use an automation to copy that calculated result into a regular date column that can trigger other automations.

For example, create a formula column called "Calculated Deadline" with ADD_DAYS({Start Date}, {Project Duration}). Then create an automation: "When Start Date changes or Project Duration changes, copy Calculated Deadline to Deadline column." Now your Deadline column contains the calculated date and can trigger reminder automations when that date arrives.

This approach works well for projects where start dates and durations change infrequently. The automation fires whenever the inputs change, keeping the deadline column synchronized with the formula calculation.

Workaround B: Workflow Builder for Complex Date Logic

Monday.com's newer Workflow Builder provides more sophisticated automation logic, though its integration with marketplace apps like Community Cookbook is still evolving through the 2026 rollout. Workflow Builder can handle multi-step calculations and conditional date setting that native automations cannot.

Within a workflow, you can create conditional branches: if project type equals "Standard," set deadline to start date plus 10 days; if project type equals "Complex," set deadline to start date plus 20 working days. This level of conditional logic is impossible in native automations but essential for organizations with varying project types.

The limitation is that Workflow Builder still cannot directly reference formula column results or perform inline date arithmetic. You'll still need formula columns for the calculations, but workflows can provide more sophisticated rules about when and how to apply those calculations.

Community Cookbook Solutions for Relative Date Automation

Community Cookbook provides several recipes that fill the relative date automation gap:

Set Date to Today Plus N Days: This action can set any date column to the current date plus or minus a specified number of days. Perfect for recurring task creation where due dates should be relative to the automation trigger time rather than a specific column value.

Copy Formula Result to Column: Essential for the formula column workaround described above. This action can copy calculated dates from formula columns into editable date columns that can trigger other automations.

Extract Timeline Dates to Date Columns: If you're using timeline columns for project scheduling, this action can extract the start and end dates into separate date columns where they can trigger automations or be used in notifications.

These recipes integrate naturally with monday.com's native automation system, appearing in the action dropdown alongside built-in actions. Unlike external integrations, they don't require additional subscriptions or complex API setups.

When to Use Each Approach

Use formula columns alone when you need calculated dates for display and reporting, but don't need those dates to trigger automations. This works well for dashboards showing calculated project milestones or deadline countdowns.

Use formula columns plus copy actions when calculated dates must trigger other automations. This is the most versatile approach for complex project scheduling where deadlines depend on multiple variables.

Use workflow builder for projects requiring complex conditional logic around date calculations. If your date-setting rules have multiple branches or dependencies, workflows provide better structure than multiple individual automations.

Use Community Cookbook recipes to eliminate the manual steps in any of these approaches. The recipes handle the mechanical work of copying formula results or setting relative dates, letting you focus on business logic rather than technical workarounds.

For comprehensive guidance on setting up formula-based automation workflows, see our post on dynamic automation logic using formula columns. Organizations scaling these approaches across multiple departments should also consider our guide to automating date calculations for dependencies and timelines.

The Business Impact of Automated Relative Dates

Manual date management becomes unsustainable as project complexity grows. When a client moves their go-live date, teams shouldn't spend hours updating dependent task deadlines across multiple boards. When a new project template is created, subitem due dates should automatically calculate based on project start dates and task durations.

Automated relative date calculations enable responsive project management. Marketing campaigns can automatically adjust their milestone dates when creative approval timelines change. Manufacturing projects can cascade deadline updates through their entire production schedule when material delivery dates shift.

The formula column plus automation approach scales to handle hundreds of items with complex date dependencies. Once the calculations are defined in formulas and the copy automations are in place, teams can focus on executing work rather than maintaining date accuracy across their project portfolios.

Frequently Asked Questions

Can I trigger an automation when a formula-calculated date arrives?+

How do I set subitem due dates relative to parent item start dates?+

What's the difference between ADD_DAYS and WORKDAY functions for deadline calculations?+

Can I set timeline column dates automatically based on calculated values?+

Why don't my relative date automations work with mirrored columns from other boards?+

How do I prevent automation loops when syncing calculated dates between boards?+