Search Dates on all colunms
problem is, I have have about 6 columns for date_1, date_2, date_3 etc because a few of the events are on more than one date. See attachment. On one of the events the 7th July is in column date_1, whereas it may be on column date_2 on another event. But I want it to search though all the date columns but only display the event from say the 7th July and not showing the date of 6th July from 1st Column. I know this must sound confusing but I just can't think of any other method to do this and deadline is looming.