Help

How to Track Room Utilization By Date?

Topic Labels: Formulas
570 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Can
6 - Interface Innovator
6 - Interface Innovator

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?

0 Replies 0