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

This topic has been closed for replies.

+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