Hi,

I am trying to develop an excel application for an Event house.

They have two houses and each will have business slots booked throughout the year. These slots will be in hours. They are open for 8 hours every day.
Slots are booked in the following way.
5th April to 7th April for 20 hrs, means
8 hrs on 5th April
8 hrs on 6th April and
4 hrs on 7th April
Booked Slots.png

I want to have a forecast for the next 1 week in the following way: if fully booked in Red, Fully available in Green and Partly available in Pink with hours available
Dashboard.png

Can I have get some help in getting this done using VBA? Or is it possible to get this done with Formulas? Guidance will be of a lot help.

Sample file attached - Allocation Template.xlsx

Thanks in advance,

regards,
Ravi.