Skip to main content

Set the Due Date as the previous Workday formula

  • July 26, 2021
  • 1 reply
  • 16 views

Hi all -

Looking to create a formula where based on the Publish Date of a record, the previous Weekday will become the Due Date. The Publish Date also have a time associated, so not sure if that causes issues - but the Due Date field doesn’t need a time.

Where I’m hitting a roadblock is making sure the Due Date is always a Weekday, so not requests are coming in as Saturday or Sunday requests.

Thank you all in advance!

This topic has been closed for replies.

1 reply

Kamille_Parks11
Forum|alt.badge.img+27

The formula would be

WORKDAY({Publish Date}, -1)