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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!