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!

Please post a sample file - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Attached is a sample file with incoming requests that our team needs to work on. I've highlighted rows that cross over into additional months. I would like to be able to filter on a month within the Start Date and End Date. For example, in row 4 the Start Date is 9/1 and End Date is 11/5, so in theory we are working on that request over the course of 3 months. I'd like to be able to filter on the month of Sept, Oct or Nov and see that request.

Thank you again.

Attached Files

SampleIntake.xls (37.5 KB, 11 views)