Marking this as unsolved for a moment as I have a follow-up question (if that's not allowed nevermind this and I apologize!)

I'm wondering if it would be possible to calculate streaks in the sheet, as in longest W or L streak? It would need to span rows from one day row to the next in case one day ended in 3 Ws and the next day began with 2, so a 5 W streak over 2 days.

Thanks for any help!