Counting only weekdays Formula?
Hello,
I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current to capture the amount of days it has been open. Also while I need it to count the amount of days its been open i need it to stop counting if the date closed is there.
Formula; =IF(Status@row = "Closed", [Date Closed]@row - [Date Opened]@row, TODAY() - [Date Opened]@row)
Answers
-
I think you will need to use NETWORKDAYS in your formula.
-
Hi Maybe I am not understanding the NETWORKDAYS formula but while i understand the formula as a whole how do i make it so its every weekend. I see that i can put holidays but do i have to list every weekend? Tickets can be places when every so how would i have it exclude every weekend?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!