LinkBack URL
About LinkBacks
Check out my sample workbook with sample reservations listed - I need a formula to calc how many IN HOUSE reservations there are at any given time AND based on 22 properties, what my occupancy % is at any given day. Thanks guys!
Sample Book.xlsx
Hotel Reservation Spreadsheet - check in & out dates listed - need total in house & occ %
Check out my sample workbook with sample reservations listed - I need a formula to calc how many IN HOUSE reservations there are at any given time AND based on 22 properties, what my occupancy % is at any given day. Thanks guys!
Sample Book.xlsx
There is no data regarding occupancy and what are you referring to when you say in house?
sorry Bill - Notice the check in and check out dates as a range - I need to have a total of in house (meaning if a certain date listed below on left falls in the range of check in and out it creates a 1 to then be totaled together for a total of all in house) in the column below labeled "total in house" and then take that info and create a total occupancy for the day based on the total # of in house out of a total of 22 properties
Another easier way to think of in house is this example - Check in June 1 and check out June 3 - June 1st, 2nd & 3rd this property would be "in house"
IN B19 use
In C19 use (Format C19:C31 as %)
Please Login or Register to view this content.
And drag down both.Please Login or Register to view this content.
YOU sir are an Excel genius! Thanks a tonOriginally Posted by kvsrinivasamurthy
IN B19 use
In C19 use (Format C19:C31 as %)Please Login or Register to view this content.
And drag down both.Please Login or Register to view this content.
Welcome. Pl mark the thread solved.
How would this formula work if you didn't want the check out day calculated into the total? Technically that last day opens up, as people are checking out. Thx.
iheartglamour,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks