I am using an excel file to count the hotel reserved room counts by entering the reservation details, for example:
if guests reserved 25th till 30th 2 double, it should the total rooms consumed from 25th till 30th, each day 2 units
if another guest booked from 25th till 27th 5 double rooms...