Help

Work days for Sunday-Thursday

Topic Labels: Formulas
Solved
Jump to Solution
298 2
cancel
Showing results for 
Search instead for 
Did you mean: 
dani_d
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

2 Solutions

Accepted Solutions
Pascal_Gallais-
6 - Interface Innovator
6 - Interface Innovator

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

See Solution in Thread

dani_d
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

2 Replies 2
Pascal_Gallais-
6 - Interface Innovator
6 - Interface Innovator

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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