Gnatt chart - list cells from 'tasks' columns based on date

[Alan1180_]

See the example sheet attached. 

I have a Gantt chart with a list of tasks on the right and dates along the top. 

On a new sheet, I would like to be able to select a date range with the result being a list of tasks that are active within that date range.

Thanks very much in advance you wonderful bunch!

[#2]

@Alan1180_ Hoping you are on an Excel version that supports the FILTER function. See attached.

[#3]

@Alan1180_ 

See the attached version. It uses the FILTER function.