Here is a different way to approach this.
I took your example and created 6 formulas so you can see 6 events per your calendar days
The first formulas goes in cell D15 of worksheet 2. The others goes in your merge cells from C16 to C20
Formula:
=if(countif(event_dates,c15)=0,"",INDEX(events,MATCH(C15,event_dates,0)))
=if(countif(event_dates,c15)-1<=0,"",INDEX(events,MATCH(C15,event_dates,0)+1))
=if(countif(event_dates,c15)-2<=0,"",INDEX(events,MATCH(C15,event_dates,0)+2))
=if(countif(event_dates,c15)-3<=0,"",INDEX(events,MATCH(C15,event_dates,0)+3))
=if(countif(event_dates,c15)-4<=0,"",INDEX(events,MATCH(C15,event_dates,0)+4))
=if(countif(event_dates,c15)-5<=0,"",INDEX(events,MATCH(C15,event_dates,0)+5))
Hope this helps
Bookmarks