Booking Calender - Lookup multiple bookings across date ranges for

Hi,

I'm trying to create a booking calendar in excel (attached), but having issues when I have bookings for different demos on the same date, it only shows as one demo booked out at a time.

So the front tab is the calendar, which looks up bookings from the booking form tab, and on there you will see multiple bookings for different demos and date ranges. Where date ranges overlap each other on the different demos, only one of the bookings appear on the calendar tab. I need to find a way to show all bookings on the calendar tab, so asking for advise as to how I can tweak my formulas to do so.

Can somebody please review and advise? Hoping this will be a simple task for someone as it's driving me crazy trying to fix this!

Thanks!

I would suggest that in your Booking Form sheet you generate another table which expands those date ranges into individual days (automatically), and then the formulae in the Calendar sheet would become a lot simpler and could cope with overlapping ranges. Would you need any help in setting it up this way?

Hope this helps.

Pete

Ah well, I went ahead and did it anyway after a cup of coffee - see attached file.

If you need any explanations of any of the formulae please feel free to post back.

Hope this helps.

Pete

Pete, that has done the trick! I have copied this over to my master file, and it is working like a dream.

Thank you for your super quick support and assistance on this! This has saved me a lot of stress!

Also, thanks to Ali for also trying to help me on my issue.

PROBLEM SOLVED!

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete