I have a base now where I track events and rooms the events occur in (not that I’m doing much of this during coronavirus).
Each event is given a start date and end date. Usually 1 or 2 days. Each event is also tagged to a Room. Like say Room 1 or Room 2.
What I’d like to do is essentially track room utilization over the quarter. So if I have 4 events, and each one lasts two days (so the start date is say 1/1/20 and the end date is 1/2/20) and each is tagged to a room, how would I craft a formula to total up the days per room?