Look at the sample worksheet and in cell B19. Look at the formula, I need to remove the last day of the formula which is the checkout day. I ultimately need to see who's in-house on any given day/ date from the check in and out date ranges BUT I forgot to mention I do NOT need the checkout date to count towards in house or not... Am I making sense? The occupancy should always only be as high as 100% also which takes in account the total in house...
Sample Book.xlsx
Have you tried removing the equal sign?
Change this:
to this:
Please Login or Register to view this content.
Cheers,Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Didn't seem to remove the checkout date from the sum of the in house totalOriginally Posted by ConneXionLost
Have you tried removing the equal sign?
Change this:
to this:Please Login or Register to view this content.
Cheers,Please Login or Register to view this content.
Did you copy the formula down?
No I just removed the =
Is anyone else able to help take a stab at this?
Hello TheVodkaDude,
Had to edit this as it just occurred to me that you are a MAC user so none of this may apply!
I'm new to this forum. I've an answer to your question that may be of some use to you. If not then, my stab was in vain!
I have Excel 2010 which may make a difference. I tried two things.
First, I subtracted the dates and subtracted one for the last night occuppied:
Then used SUMIF to extract dates the rooms were occupied.Please Login or Register to view this content.
I've attached the file (at least I hope I have) to clarify.Please Login or Register to view this content.
Here's hoping it worked!
Last edited by Faylinn; 07-07-2013 at 07:25 PM. Reason: Realised that your question related to a MAC.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks