Forum Discussion
Hotel room avail showing in monthly calendar
I need some help. I need to build a spreadsheet that shows I have 20 hotel rooms available each day from April 16th 2023 to April 30th 2024 (10 rooms for group A and 10 rooms from group B). I ...
See the attached simple demo. It uses COUNTIFS.
- HansVogelaar
Thank you so much. Do you know if there is away for excel to show the information in a calendar? for example, I would like the month of May 2023 listed and it shows us the total number of rooms available after we put in the check in/check out date. I am brand new to excel and trying to learn.In the attached workbook, I used a template from Microsoft for a monthly calendar and modified it to display the number of available rooms. You can select a different month from the month drop down.
