Difficult COUNT IF problem (sequence based on date)

Hey there!



What I would like to have is to categorize different events on a specific day. Besides many options there can be a 'R'. If there is a 'R' and the date is (Today), Excel should look for the streak how long it is already a 'R'. In this case it would be 4 day. The output '4d' woulde be now shown in the column Time. If the the sequence is interrupted the count would go back to 0.

I struggled with the formulating the input to get a proper sequence if there is an interruption. The only thing I get are absolute counts.


Cheers.