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?
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
Genius! Thank you, this worked like a charm!!
Here's another solution.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.