Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Set automatic Date excluding Weekends

Topic Labels: Automations
1425 2
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!