Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=381039 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP - Room booking spreadsheet hell | Excel Discussion (Misc queries) | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
ICT Room booking system | Excel Discussion (Misc queries) |