Remove Holidays
I am trying to get the number of days a case has been opened that excludes days I have entered as holidays. For instance. I have date assigned, disposition date and the type of review level the case is. I created a column to capture all case review levels (first formula listed below) and a 2nd formula so I can reak it down by review level separately. But…they numbers don't match, which i have to assume is because in the 2nd formula i didn't account for the holidays. When i try to add holidays it gives me an error message.
This is the first formula I have in Days to Close column =IFERROR(NETWORKDAYS([Date Assigned]@row, [Disposition date]@row, Holidays:Holidays), " "). This formula provides me with 109 as the answer
The second formula I have is in the CRU 2 close column: =IF(AND([Review Level]@row = "CRU-Phase 2", [Disposition date]@row <> ""), NETWORKDAYS([Date Assigned]@row, [Disposition date]@row), ""). This formula however gives me 124.
Answers
-
How are you adding holidays to the second and what error message are you getting?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives