Ok ...this is sooooo cool
So basically once a guest checks in say "XXXXX XXXXX" if his dates are 12/6 thru 12/8 and he is designated as "ACM" I want to be able to just put those checkin dates and have the sheet populate "ACM" in the columns P and Q and then leave the other columns blank....
now if he was staying for example 12/6 thru 12/12 but the nights of 12/6 thru 12/7 are "ACM" but the nights of 12/8 thru 12/11 are "IPO", I want to be able to put those date in those columns and have it put the wording "ACM" under the "ACM" night columns and "IPO" under the "IPO" night colums and have blanks in the other columns...
The current formula in O2 is incomplete ... It only has enough formula " ifs" for the "ACM" and "RCM" values....I could not get the "IPO" IF formula added because it exceeded the 7 ifs....so once you fiqure out how to add more "ifs" you can do it for "IPO" portion ..... also I don't want it to say "false" if they did not stay a night....do I need to use a different type of formula???
That is looking good.... were you able to test it by just putting dates in one of the columns say 12/6 thru 12/13 just in "RCM" and then test another line say Robin Adkins and put for example 12/5 thru 12/7 in "ACM" and 12/7 thru 12/15 in "IPO" and have it populate correctly in the O thru Y columns???
Yes ...that looks right ....
How is it going? .....should I go to bed and get this tomorrow?
Hey I cannot open the file can you send it to my email
Thank you so much.... you did a great job and I will definitely recommend you!
Attachments are only available to registered users.
I have a new formula I need help with...how do I proceed?
"For Jess M"
I need to compare the date in column A1 to the date in column B1 and which ever date is GREATER....then put that date in column C1. Note sometimes there may only be one date (either in A1 or B1, in that case put that date in column C1)