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.5K Get Help
- 425 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives