Solved

Work days for Sunday-Thursday

+3

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?

Best answer by Pascal_Gallais-

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

+21

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

+3

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

+10

Here's another solution.

Sign up