Dear All

I have a problem with the excel sheets, I need your help
I have a hotel booking system I have to make it, we need to know each day what are the available rooms and the booked rooms, we want to create a booking board to have a snapshot of each day
We already have a master list for each booking and the details of the booking ,
We would like to have the last name of the person who has booked the room on the booking board only the last name, and the vacant room appear like vacant on each day ,
Note on master list we only have check in date and check out date
So the formula should determine the specific date that a person was on the hotel and take his last name to the booking board
The beg board should be available for a whole month or week by specifying the dates:
From 1-4-2014 to 7-4-2014