Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Set the Due Date as the previous Workday formula

237 1
Showing results for 
Search instead for 
Did you mean: 

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

The formula would be

WORKDAY({Publish Date}, -1)