Get No. of Days Open for incident Excluding Holidays in a Report
SummaryGet No. of Days Open for incident until closed Excluding Holidays in a Report
I have a requirement of report having a column which displays no of days open for an incident, but the problem is that it should not include holidays, i.e for example if an incident was created on 17/04/2019 and closed on 22/04/2019, and the holidays in between these days were : 18/04/2019, 20/04, 21/04. Then this column should display 3 Days. These Holidays are already defined for this year. I am not able to achieve this by any standard means known by me. So is there any way to achieve this and how?