The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
‎Jun 20, 2024 05:42 AM
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?
Solved! Go to Solution.
‎Jun 21, 2024 02:50 AM
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
‎Jun 23, 2024 04:25 AM
‎Jun 21, 2024 02:50 AM
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
‎Jun 23, 2024 04:25 AM
Genius! Thank you, this worked like a charm!!
‎Sep 01, 2024 12:41 PM