Can you filter data by month between a start date/end date?

[JFromFla]

Hi,

I was given a sheet with a list of projects. It has a start date column and and end date column, and further information about the project (title, manager, budget) are in other separate columns. I have been trying to find a way to be able to select a month and year in a pivot table and have it return projects that are in between the start and end dates.

Here's an example:

Project Name	Project Manager	Percent Complete	Start Date	End Date
PB&J	Skippy Smuck	50%	12/2/2019	6/7/2020
Pizza	Domino Pan	60%	1/5/2020	2/2/2020

I want to be able to select May 2020 and the PB&J project info pops up, but not the Pizza project because it isn't in the Start/End date range.

Any help is appreciated, thanks!

 

[denzo36]

Hi there, this would seem to be straightforward enough if you had another column that look at your target date and had a simple logic that your selected date was >= start date and <= end date.

Could you share how your spreadsheet looks now and what you want it to look like?