Calculating the layering of the dates

Good afternoon. I will be glad of any help. I’m trying to solve the following problem:

Employees use the form to book a room for events (work meetings). There is the start date of the event, the duration and the end date of the event (formula: start date + duration).

How to make sure that the user who makes a new booking request receives a booking notification of the type “Your application is accepted”, or if the dates overlap, “The following events are planned for this time: “event name””.

I am only interested in the formula for calculating the layering of the date of the current event on others.

I do not know how you want to do this with a formula.
I’d use a script.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.