Spreadsheet: 740822d1626610377-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting
Sheet: Room Reservation

 |  |  |  |  |  |  |  |  |  |  | VILLA AVAILABILITY TABLE FOR PERIOD: |  |  |  |  |  |  |  | 2021-05-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 1 | Available |  | 0 | Not Available |  |  | -1 | Double Reservation
 |  |  |  |  |  |  |  |  | Enter Date here
 |  |  |  |  |  |  |  |  | 2021-05-20 00:00:00 |  | 0
Room Type - for calendar | Room No - only for calendar | Guest Name | Check In | Check Out |  |  | No | Room Type | Room Number |  | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Standard | 1 | Guest 1 | 2021-05-20 00:00:00 | 2021-06-02 00:00:00 |  |  |  |  |  |  | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-22 00:00:00 | 2021-05-23 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2021-05-29 00:00:00 | 2021-05-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00
Standard | 1 | Guest 2 | 2021-06-03 00:00:00 | 2021-06-07 00:00:00 |  |  | 1 | Standard | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Standard | 3 | Guest 3 | 2021-06-04 00:00:00 | 2021-06-10 00:00:00 |  |  | 2 | Standard | 2 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Standard | 3 | Guest 4 | 2021-06-07 00:00:00 | 2021-06-10 00:00:00 |  |  | 3 | Standard | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | -1 | -1 | -1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Standard | 1 | Guest 5 | 2021-06-07 00:00:00 | 2021-06-10 00:00:00 |  |  | 4 | Standard | 4 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | 5 | Standard | 5 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Standard | 3
 |  |  |  |  |  |  | No | Room Type | Room Number |  | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon
 |  |  |  |  |  |  |  |  |  |  | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00
 |  |  |  |  |  |  | 1 | Standard | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | 2 | Standard | 2 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | 3 | Standard | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | 4 | Standard | 4 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | 5 | Standard | 5 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1