FILTER BY NEXT WORK DAY, LAST WORK DAY

[dani_d]

I need to calculate the number of days a ticket was open, but excluding weekends.

However, Airtable wont let me change my work days to be Sunday-Thursday.

What formula can I use as a workaround, to count all days of the week minus every Friday and Saturday of the year?

[Pascal_Gallais- · Accepted solution]

Hello Dani,

Here is a document that explains how you can exclude Fridays and Saturdays from you number of days.

It may not be the simpler solution, but it does the job.

Regards

Pascal

[dani_d · Accepted solution]

Genius! Thank you, this worked like a charm!!

[OfficeOurs]

Here's another solution.