+5Heya,
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)
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
+5There 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
Thank you verry much Sho!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.