Problem Statement:
Column B through D track a rolling count of items that are open and closed for a duration of the last 30 days based on today's date. (Blue table)
I'm trying to accomplish the same function by using rolling weeks instead. (Yellow Table)
This is simple, but I've been at this...