Forum Discussion
Show a cell value during a specific period!
i have an offer with the hotels within a specific booking window, so i need to show the hotel name in different excel sheet but within the booking window, for Ex:
Bella vista: Booking window from 01.05.23 till 15.05.23.
so, how can i add a formula to show the hotel name in a cell only during the above-mentioned booking window period?
4 Replies
Please provide detailed information about the setup. Do you have a list of hotel names and start/end dates?
It would be useful if you could attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.
Hotel Name Booking Window From To Royal Savoy SSH 28.03.23 18.04.23 Cleopatra Luxury SSH 20.03.23 15.04.23 Labranda Tower Bay 16.03.23 15.04.23 See the attached sample workbook. I hope you can adjust the formula for your situation.
