Does 'today' mean the moment the trigger fires or the calendar date?

It uses the calendar date (midnight UTC) when the trigger fires. So 'today + 7 days' always means exactly 7 calendar days from the trigger date, regardless of the time.

Can I set dates in the past using a negative number?

Yes. Setting N to a negative number calculates a date before today. For example, 'today minus 30 days' sets the date to 30 days ago — useful for backdating records or setting reference dates.

Does this account for weekends and holidays?

The action uses calendar days, not business days. If you need to skip weekends, increase N accordingly — for example, use 9 days instead of 7 to account for a weekend.

Action

Set Date to Today Plus N Days

“Set a date column to today's date plus or minus N days”

Automatically calculate and set a date relative to today. Create dynamic deadlines, follow-up dates, and SLA timelines that adjust based on when a trigger fires.

Use Cases

Set a 'Follow Up' date to 7 days from today when a lead status changes

Create a 30-day deadline when an item enters the 'Active' phase

Set a review date 90 days from today when a contract is signed

Real-World Example

Your sales board needs follow-up reminders. When a deal status changes to 'Proposal Sent', this action sets the 'Follow Up Date' column to today + 5 business days. Combined with a 'when date arrives' automation, you get automatic reminders exactly when it's time to follow up.

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