Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2016, 07:45 AM
Triadragon Triadragon is offline Find if Date range falls within another range Windows 10 Find if Date range falls within another range Office 2016
Novice
Find if Date range falls within another range
 
Join Date: May 2016
Posts: 2
Triadragon is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Excel date range.xlsx (17.9 KB, 12 views)
Reply With Quote
  #2  
Old 05-02-2016, 08:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Find if Date range falls within another range Windows 7 64bit Find if Date range falls within another range Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hello

like this?
Attached Files
File Type: xlsx Copy of Excel date range.xlsx (24.2 KB, 31 views)
__________________
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
Reply With Quote
  #3  
Old 05-02-2016, 09:41 AM
Triadragon Triadragon is offline Find if Date range falls within another range Windows 10 Find if Date range falls within another range Office 2016
Novice
Find if Date range falls within another range
 
Join Date: May 2016
Posts: 2
Triadragon is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Hello

like this?
Exactly what I needed - much thanks!
Reply With Quote
  #4  
Old 05-02-2016, 11:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Find if Date range falls within another range Windows 7 64bit Find if Date range falls within another range Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find if Date range falls within another range 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
Find if Date range falls within another range Filter by a Month that falls within a date range MattG1225 Excel 2 12-03-2015 07:44 AM
Find if Date range falls within another range Date Range Prompt MikeWooZ Excel 6 12-04-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft