Creating a booking calendar in Excel using SUMIFS

[Nick O]

Hi Guys,

I am trying to create a user-friendly booking calendar for advertising sponsorships across a network of sites my company represents.

I need staff to be able to use the tab labelled 'Bookings' to input a simple data set (Advertiser-Contract Number-State-Site-Section-StartDate-EndDate) and for that information to populate a Calendar on the next tab (March).

I'm reasonably familiar with SUMIFS and can use that function to match advertisers with sites and their sections but I'm having real trouble getting the dates right.

Essentially I need a function that will populate cells of a calendar if the date falls between a date-range stipulated on the bookings tab and if it matches the site & section. Either that or the knowledge that it is not possible.

Example attached. Thanks so much if anyone can help!

Cheers,
Nick.