Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Set automatic Date excluding Weekends

1005 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Goran
5 - Automation Enthusiast
5 - Automation Enthusiast

Heya,

just a Formula newb here 🙂 Im Trying to set automaticly the Date 3 day before. When i set a Date manualy in a Field, another one should display a date 3 days before excluding weekends.

I just only managed 3 days before but weekends are still included.

Here my formula (Datefield is my manual selected field)

Formula:  DATEADD(DATEFIELD, -3, "day")     
 
Thanks for any advice!
2 Replies 2
Sho
11 - Venus
11 - Venus

There is a function called WORKDAY().
This can be used to calculate operating days with Saturdays, Sundays, and optionally specified dates as vacations.

 

WORKDAY(DATEFIELD, -3, '2024/1/1')    

Formula Field Reference - Overview | Airtable Support

 

Goran
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you verry much Sho!