- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 23, 2024 04:25 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 23, 2024 04:25 AM
Genius! Thank you, this worked like a charm!!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2024 12:41 PM
