Can we create a workflow to run daily and alert when due date reached excluding Saturdays & Sundays

Archana Sahu

We need to create a workflow to run daily and send an alert when due date (Due date = Created date + 2days) is reached, however weekends should be excluded, as when a request is created on Friday, so for due date it should count Monday and Tuesday instead Saturday and Sunday. Is this possible to set a workflow for this?

Paul Newcome

If you use a Friday date in a WORKDAY function and add 2 days to it, it should populate a Tuesday date. A Thursday date with WORKDAY + 2 should populate a Monday date.

Then set up your automation to trigger on the new date column.

Paul Newcome

I would suggest inserting a date type column and using something like the below:

=WORKDAY(Created@row, 2)

Then drive your automation off of this new column.

Archana Sahu

I applied the same, but it counts weekends as well, Saturdays and Sundays should be excluded

Paul Newcome

If you use a Friday date in a WORKDAY function and add 2 days to it, it should populate a Tuesday date. A Thursday date with WORKDAY + 2 should populate a Monday date.

Then set up your automation to trigger on the new date column.

Archana Sahu

Thank you very much Paul, it works!!!

Paul Newcome

Happy to help. 👍️