I have a spreadsheet that is being used to track project tasks for a digital team. We have various tasks, some with quick turnaround times (within a few days), to longer periods (over a few months).

The main header columns are Tasks Name, Target Month, Start Date and End Date. The Target Month is the month that the project is in flight and should "go live". This is the primary filter that we use to see what we have to work on.

Where I'm having difficulty is when a task runs through multiple months. For example, if a task has a Start Date of Nov 1, 2015 and an End Date of Jan 15, 2016, I'd like to be able to see that task display when I filter on the Target Months of Nov 2015, Dec 2015 or Jan 2016.

Is there a way I can do this.

Appreciate your help!