Look up if dates in range and return all true values

Hey all,

Stuck on a formula, I'm trying to get the cells on this calander to check if there is something on the day. It needs to check if it's date falls on or inbetween any of the dates of events, then return all the events names that do on a new line each.

I've attached the file below, on the January sheet, in the big square next to the 14th is a formula i tried, it half works, it does the test but only returns one value it finds. it also shows what it references


Let me know if there are any questions

Thanks

Bensley

Hey JieJenn

Thanks for the video, i had a look through it, it pretty much covers a different way of where i have gotten up to, but i will have multiple values that will match that criteria and i want them to apear in the same cell but a line down.

I've submitted several calendar files to this forum (you can search the site for examples). My approach is to have several rows for each day (e.g. 7, or 10, or 12 etc.) which will then determine how many events can be displayed for each day. I can then have a formula which can be copied down to pick up the 1st, 2nd, 3rd event etc. for each day.

With your approach of having one row per day, you would need a lengthy formula which concatenates the multiple events separated by the Alt-Enter character to force each event onto a different line within the cell. Such a monster formula would be difficult to maintain, so I would suggest you re-think how your events are displayed.

Hope this helps.

Pete