I have created a base to control the occupancy of a hotel car park, I need to control the occupancy of each day to avoid exceeding the maximum occupancy, with the formulas that I am using I can only control the number of entries or exits of a date but not the number of places occupied each day. If I have 10 parking spaces in total and I reserve 9 spaces between June 1 and June 15, I need to know that on the 10th, for example, I only have 1 space available, can someone help me find the base structure or the formulas i have to use? Thanks for the reply
