Count days on date change

[JWTurner]

Hi, I have a metric that counts the number of days we have gone without specific types of issues occuring. I created a simple calculation:
=(B9-DATE(YEAR(B9),1,0))-Incidents!C1

This takes the current number of days in the year and subtracts the number of issues we've experienced. What I failed to take into consideration is if we have multiple issues in one day. I want to track the total number of incidents separately but I don't want it to have impact on the number of days without these specific issues and the formula I'm using above does.

Specifically what I want to do is:

• Count up the number of days with at least one issue
• Subtract that total from the number of days in the current calendar year
• Multiple issues occuring within one day only counts as one day in the calculation

If you have any ideas about the formula to do this, I would appreciate it.
Thank you for any time you spend working on this.


Best Regards!
JWT

 

[SQUIDD]

Have you got a small sample of your sheet to look at??