What happens if the source date column is empty?

If the source date is empty, the action does not write to the target column. It only calculates when a valid source date exists.

Can I use this to create cascading deadlines from a single date?

Yes — that's one of the best use cases. Set up multiple automations from the same source date with different offsets: 'deadline - 5 days' for QA, 'deadline - 3 days' for shipping, 'deadline - 1 day' for final check.

Does the target date update when the source date changes?

Yes, if you use a trigger that fires when the source date column changes. Each time the source date is updated, the offset recalculates and the target date is rewritten.

Action

Copy Date Plus N Days

“Copy a date column and add or subtract N days”

Read a date from one column, offset it by N days, and write the result to another date column. Build cascading deadlines and buffer periods from a single anchor date.

Use Cases

Set a 'Review Due' date to 3 days before the project deadline

Calculate a 'Ship By' date as 2 days before the customer's delivery date

Create milestone dates offset from a project start date

Real-World Example

Your delivery board has a 'Customer Delivery Date'. This action calculates 'Must Ship By' as delivery date minus 3 days, and 'QA Deadline' as delivery date minus 5 days. When the delivery date shifts, the cascade updates automatically — keeping all intermediate deadlines accurate.

Ready to use this recipe?

Get Community Cookbook from the monday.com marketplace and unlock every custom trigger and action. Always £9.99/month — the recipe list keeps growing but the price never goes up.

Get the App Get monday Help