Hello - I am trying to figure out how to calculate room nights stayed at a hotel PER DAY based on the check in and check out dates. If someone can please help me, i'll love you forever!!! Below is the information needed to figure out.

"Check-In
Date" "Check-Out Date

3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/13/16
3/11/16 - 3/12/16


Room Nights
3/11/16 - 9
3/12/16 - 8


There are 9 rooms booked, and I just need it to calculate automatically to show how many room nights there are per date. I look forward to responses!