HELP - Room booking spreadsheet hell

  • Thread starter Thread starter Mark Murphy
  • Start date Start date
M

Mark Murphy

Hi,

I am trying to get a spread sheet to do the following...

I get data like Room 23, 4-july-2005 to 6-july-2005 9-july-2005 to
12-july-2005

What i need to do is find the days its empty to organise cleaners.

If binaries are allowed let me know, might make it easier to understand.
I can send what i have, but the formula eludes me,
 
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")
 
If you're just trying to find the difference between dates, you can subtract the
cells and format that cell as General (xl may try to help and format it as a
date).
 
Not sure I understand. If you want the dates between which the room i
free, then you already have them. If you want the number of free day
between one departure and the next arrival, just subtract one from th
other. Or am I being a tad thick here?

Ga
 
Back
Top