Stop duplicated with multiple cells [Closed]

Report
Posts
1
Registration date
Friday February 3, 2017
Status
Member
Last seen
February 6, 2017
-
Hello,

I have a holiday home that I rent out and I am making a spreadsheet to control bookings, I have it set up so that the entry date and departure date are on one sheet and it automatically updates a calendar on another sheet to highlight the cells when a booking is made. I am trying to set up a Data Validation formula for the column of date of entry so that it won't allow double bookings and comes up with a warning if a new booking is made between dates already booked. Can anyone help with setting up a formula in data validation to stop this or is there another way of doing this>

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!