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

[Pamela Laurie]

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.

[Deleted user · Accepted solution]

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}."

[Pamela Laurie]

Tara, THANK YOU!!!  No, it had not been answered, so I've been manually changing it this whole time.  I was sure there was a solution but it just hadn't made it to the top of my priority list to dig into it further so I kept hope alive that someone would respond. 😁