Thread: HELP - Room booking spreadsheet hell

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,


--


Thanks,
Mark.

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).





Mark Murphy wrote:
>
> 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")

--

Dave Peterson