HELP - Room booking spreadsheet hell

#1 06-21-2005, 05:05 PM

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.

#2 06-21-2005, 06:05 PM

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

#3 06-21-2005, 07:05 PM

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

gazornenplat · #4 06-21-2005, 10:02 PM

Not sure I understand. If you want the dates between which the room is free, then you already have them. If you want the number of free days between one departure and the next arrival, just subtract one from the other. Or am I being a tad thick here?

Gaz

Welcome to the Excel Forum

Forum Statistics