Feb 15 2022 03:30 AM
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!
Feb 15 2022 03:52 AM
@Alan1180_ Hoping you are on an Excel version that supports the FILTER function. See attached.
Feb 15 2022 03:58 AM
See the attached version. It uses the FILTER function.