Here's an idea of what i have..

House No: Date In: Date Out: Date Cleaned: Next Rental:
5 18/06/2005 20/06/2005 20-Jun-05 20/06/2005
9 18/06/2005 25/06/2005 25-Jun-05 02/07/2005



I want a formula to tell me what days it is free between.

I know you can read them off the spreadsheet but i am going to have to find
it in the back end because my target audience will mess with it.

As you see with room 5 its cleaned the same day, with room 9 you have a few
days
available. If there is a way of showing that then let me know.
I used this, but its not really what i want...
=IF(DAYS360(C50,E50),DAYS360(C50,E50),"URGENT")