How do I display the name of an occassion between two dates? (Part of formula include

[mscola]

Hi

I have two worksheets. In sheet "Date", I have a start date and an end date.
The second worksheet contains a list with all special occassions. There are two special occassions in one week.

As you can see from my screenshots, I'd like Excel to display the name(s) of
the special occassion(s) if it falls between the start and end date.

What is the easiest approach? With a formula or with VBA/custom function?
I've tried following formula from D2 downwards, but it won't display all dates that might be in one week.

Please Login or Register  to view this content.

I am not very familiar with VBA, so I would need your help.

Thank you for your help. I've attached the spreadsheet to this post.
I appreciate your help.

Massimo