Find if Date range falls within another range
Hi, I have 2 columns of dates that specifies a range (start and end). These are essentially project dates of when something starts and ends. I am trying to figure out how to count the number of projects that fall within a given time period.
For example, if a project starts 1/1/15 and ends 11/15/15, I would want to identify it as having hit the Oct-Dec quarter.
I have tried to filter individually by the start and end date if something starts or ends in the quarter I'm looking at, but it doesn't catch the projects that either start or finish in a time frame outside of the quarter I'm looking in.
Please see attachment for an example.
Thanks!
|