Table Entries in between dates

[Yohnson]

Hello Friends,

I am working on a new project and need some advice on how to solve a problem.

My table consists of entries with: Start Dates and End Dates and I want to create a monthly overivew of the dates.

Meaning, I want to have a all entries that run in the certain month (January, Feburary, March...) listed under that month.

For example:

January: Entry 1, Entry 2, Entry 6
Feburary: Entry1, Entry 3, Entry 4, Entry 5

How can I get the data out of my existing tables based on the month provided in my data?

Thank you very much for the advice!

[tanasedn]

Can you, please, attach a sample file?

[Kaper]

Using new FILTER function:

Please Login or Register  to view this content.

with input data uin columns A:C, months first days in column E and eomonth dates in column F.

See attached file