How to Calculate Hotel room nights booked, for each night, and broken down by room type?

[salsadantzr]

Hello All you wonderful Excel Masterminds!

For a while now, I've been using a formula to calculate the total hotel room nights booked based on arrival and departure dates. I also need to breakdown the results even further to include different room types.

I've included a sample document (names have been changed to protect privacy) for your review

You may reference the following link for a simplistic sample.

https://www.excelforum.com/excel-for...ml#post4837886

Thank you!