Dynamic Date Offsets Based on a Reference Date (for calendar)

Feature requests
, , ,
1

Hello Monday Team & Community,

I’m working with recurring events that happen every year.
Each year, we change the main event date of all ours events, and all associated tasks must shift accordingly (some 5 days before, some 10 days after, etc.).

:collision: The problem:

Currently, there is no way to dynamically calculate a date based on another date + X days and have the result appear in a true Date column (which is required for Calendar, Timeline, automation).

Using a Formula column to compute Event Date - X days works for logic — but:

  • It doesn’t update a real Date column
  • It’s not usable in Calendar or Timeline views
  • You can’t set reminders or automations based on the formula result

When we update our main event date, we are forced to manually adjust hundreds of deadlines. This is both inefficient and error-prone.

Suggested Feature:

Add the ability to create a Date column that auto-updates based on another Date column ± a number (from a number or status column).

For example:

  • A column “Event Date” = main reference
  • A column “Offset (days)” = numeric value (e.g., -10, +3)
  • A Date column “Calculated Due Date” = automatically updated value → used in Calendar view

Benefits:

  • One central date change updates all dependent tasks
  • Enables smart templates for annual or repeating planning cycles
  • Keeps the planning visual (Calendar, Timeline, automation)
  • Reduces human error & saves massive time

This feature would unlock real planning power in Monday.com !
It’s a crucial functionality for project managers who rely on relative deadlines, especially across recurring workflows.

If anyone else is struggling with this limitation, please upvote or share how you’re currently working around it.

Thanks!

2

@soufian.iq I absolutely need a feature like this.

Alternatively, instead of adding a new column, it would be ideal to designate a master task or date that all other tasks reference. If each task has a set duration and dependencies, updating the master would automatically adjust the rest. This functionality is critical for effective program and project management.

2 Likes
3

Hi @soufian.iq,

Upvoted it for you!

If you’re open to using apps, Calendar Plus has an automation that does what you want. It adds/subtracts a fixed number of days (business or not) to eg. your event date and writes it to another date column. You can choose to keep or discard the time component. Docs.

When From date changes, and only if status is something, Then shift Event date by 5 days into the past, skipping Saturdays and Sundays, discarding the time component, and write to Calculated Due Date

You can try the automation for free for 14 days.

–
Install Calendar Plus