#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
Hello
like this?
__________________
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 |
#3
|
|||
|
|||
|
#4
|
||||
|
||||
You're welcome
__________________
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Name a Range in a Word Document and then copy that range to the end of the doc w button click | DanNatCorning | Word VBA | 1 | 04-29-2016 10:47 PM |
Find a Date in a Range | rspiet | Excel | 3 | 02-15-2016 08:37 AM |
Check if a Date falls within a date range | OTPM | Excel | 7 | 02-03-2016 09:11 PM |
Filter by a Month that falls within a date range | MattG1225 | Excel | 2 | 12-03-2015 07:44 AM |
Date Range Prompt | MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |