Hi,
I have a base I use to request rooms. Is there a formula I can write to let me know if there is overlap in a request?
For example:
1/10/2022: I have a request for 4 large conference rooms for Group 1 from 10-12
1/10/2022: I have a request for 3 medium conference rooms for Group 2 from 1-5
1/10/2022: I have a request for 2 large conference rooms for Group 3 from 9-11
I need a column that will show me that there is overlap with the request for Group 1 and 3, but that Group 2 has no overlap. Knowing which sessions have overlap, I can adjust the schedule, or room types, to ensure rooms are assigned correctly.
Any suggestions?
Thanks!
Jeffrey