| Home |
| Search |
| Today's Posts |
|
#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") |
| 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) | |||
Threaded Mode
