Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 26, 2021 10:55 AM
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!
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 26, 2021 01:44 PM
The formula would be
WORKDAY({Publish Date}, -1)