ricafonyat
New Member
- Joined
- May 1, 2017
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hello!!
I am looking for help to build an array formula that compute by month and year the number of room nights according the hotel reservations book
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
Any help would be appreciated
Rica
I am looking for help to build an array formula that compute by month and year the number of room nights according the hotel reservations book
Hotel Reservations | ||
Check-in Date | Check-out Date | Room Nights |
Apr.30.2017 | May.02.2017 | 2 |
May.01.2017 | May.02.2017 | 1 |
May.03.2017 | May.06.2017 | 3 |
May.10.2017 | May.11.2017 | 1 |
May.12.2017 | May.15.2017 | 3 |
May.30.2017 | Jun.02.2017 | 3 |
Jun.03.2017 | Jun.05.2017 | 2 |
Jun.30.2017 | Jul.01.2017 | 1 |
Jul.02.2017 | Jul.05.2017 | 3 |
Jul.06.2017 | Jul.10.2017 | 4 |
Jul.15.2017 | Jul.22.2017 | 7 |
Jul.25.2017 | Aug.01.2017 | 7 |
Total Room Nights | 37 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Month | Room Nights |
Jan.17 | ? |
Feb.17 | ? |
Mar.17 | ? |
Apr.17 | ? |
May.17 | ? |
Jun.17 | ? |
Jul.17 | ? |
Aug.17 | ? |
Sep.17 | ? |
Oct.17 | ? |
Nov.17 | ? |
Dec.17 | ? |
Total Room Nights | 37 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Any help would be appreciated
Rica