Creating a booking calendar in Excel using SUMIFS

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.

Originally Posted by cffndncr

G'day Nick,

Quick question, what information do you want to display on the calander? Just a count of the number of bookings for that particular subsection?

Thanks for the reply...

Pretty much looking for anything that would show the date of the subsection as being booked/unavailable. So a count, or text "Booked" or even pulling in the advertisers name would be ideal.

Originally Posted by bebo021999

Try in C4:

Please Login or Register  to view this content.

this counts number of Advertiser with same site and same section during same duration.

Mate, this looks perfect. Thank you so much for that. It was driving me insane!

Thanks mate!