thx v much guys - luke m ... i varied your original formula a bit and it works well. ill have a look at your most recent posting too to see if that gives even a better solution but thx for the information. xld - ill check your solution too and let you know.
thx guys. we actually do manually allocate the bookings to a house ... either "a" or "b". and the datein and dateout are put in separate columns already .... here is a more full booking list ....
given that this keeps track of different houses, would this make the formula easier to create...
i need a formula that can check if there are overlapping dates where we have 2 houses available for rent. all bookings are shown in a single list and 2 identical dates are fine ie 2 identical bookings such as ... in-13/09/11 out-15/09/11 is fine because we can put first renter in one house and...