Action

Move Date Off Weekends and Holidays

“If a date lands on a weekend or holiday, move it to a working day”

Check a date column and, if it falls on a weekend, public holiday or company day off, move it to the next or previous working day.

Use Cases

Stop due dates landing on Christmas Day or a company closure day

Pull payment dates back to the last working day before a weekend

Clean up imported dates so every deadline is on a working day

Real-World Example

An automation sets an invoice date to the 25th of each month. When the 25th is a Saturday, this action moves it back to Friday the 24th, so the invoice goes out on a working day.

Ready to use this recipe?

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