I have a table in which I input communications opportunities (external events). These events can correspond to a single day or to a date range, which can span over several weeks.
I have been able to extract the weeknumbers corresponding to the date range defined by the start and end dates :
Then, in another table where I map our upcoming newsletters (each newsletter in a column), I also have created a column for these communications opportunities. I want it to show (only) the opportunities which happen (partially or totally) during the week corresponding to the calendar line (which is structured along the principle : 1 week = 1 row, with all weeks of the year in sequential order).
But my formula gets me ALL records of the opportunities table in EACH cell where I should get only one event.
I fail to find what’s wrong in my formula or structure…
Do you see what I miss in that ?
Many thanks for any help !