I would like formula that will return a value in a cell if the dates fall between a range of dates. I have a date in B1 and other date in B2, with the total in B3. The value to be return is in B3 in all cases and to be placed in either B6 or B7 if the date falls between certain date range of C6:D6 or C7:D7. I have attached the spreadsheet.
Thanks
Hi tsmor and welcome to the forum,
Find the attached with what I hope is your answer. You need to change your date in D7 to 2012 to have it make sense. Also I didn't calculate the number of days for split occupancy. That is what if a check-in was on Nov 10th and checked out on Dec 15th. Should they get different rates based on the season?
Find the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks