Difficult COUNT IF problem (sequence based on date)

Originally Posted by qwertz87

If the sequence gets interrupted the output should go back to 0.

You have 2 answers, one of them does that.