Having a bit of a problem....

Im developing an event calendar and I would like to know how I can populate event/activity information within a certain date box.

Currently, this is my formula to extract the information (the end result is the information concatenated, i.e. event/activity information)

Please Login or Register  to view this content.
What this does, is it plots the information where it needs to be, only problem is if an event last for more than two days, it only puts the data in those two specific dates, not the days in between.

I have a Conditional Format that when I certain string appears, it gives it a certain color. So I believe all I need is to somehow, like I said before, populate the in between cells as they do for the start/end dates.

I have attached the file to hopefully help visualize my issue.

HOpe everything Ive said helps and is clear on what I would like to get/understand.

Thanks guys.

CP

Event Calendar.xlsx