Remove Holidays

lesmickin

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.

Paul Newcome

How are you adding holidays to the second and what error message are you getting?