Forum Discussion
Month end age of incidents
Hi. I have some incident data that has incident number, date opened and date closed. Case #1 was Opened January 1st and Closed on May 23rd Case #2 was Opened January 1st and Closed on June ...
Thank you for the reply, this counts the number of incidents which a good step but in the Jan example I would count the number of days for incidents still open that were notified before 2022-01-31 and either not closed yet or closer after this date. In this example my result would be 31 as it's two incidents open on 2022-01-01 so that would be 63/2. Does that make sense?
See the attached sample workbook. The formulas are horrible.