How to automate checklist due dates so they won't fall on a weekend.

Question

I used automation rules to set due dates for items on a checklist based on a custom field: "Event Date".  Many things are due either the working day before or the day after the event, so if the event is on a Sunday, the things due the day before should be due on Friday, not Saturday.  If an event falls on a Saturday, the things due the day after should be due on Monday, not Sunday.

I have been using: set the item due on the date in custom field "Event Date" minus 1 working days or plus 1 working days, but it is pushing those items to either Thursday or Tuesday, respectively.

unknown · Accepted Answer

Hi Pamela,

Not sure if you've already solved this? I found your question while looking for an answer to my own similar issue.

Perhaps this will help, from the arithmetic and formatting resources (here)

"Note: In working days values, {date+1wd} is not the next working day but the date after a working day has passed. This subtle distinction only matters if the date falls on a weekend: Saturday +1 working day is Tuesday. To obtain the next working day, use {datelong+0wd}; to obtain the previous working day, use {datelong-0wd}."