Hey there!
Not sure if this works. But I would like to know your opinion. Find the image below:
2019-07-02 08.48.30 am.png
What I would like to have is that if there is a 'R' and the date is (Today) than Excel looks for the streak how long it is already a 'R'. In this case it would be 3 day. The output '3d' woulde be now shown in the column Time.
Is that possible to solve?
Cheers
Bookmarks