Microsoft Office Forums Check if a Date falls within a date range

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2016, 02:05 PM
OTPM OTPM is offline Check if a Date falls within a date range Windows 7 32bit Check if a Date falls within a date range Office 2010 32bit
Expert
Check if a Date falls within a date range
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Check if a Date falls within a date range

Hi All

I am struggling with a formula to check if two dates fall within a date range.
Basically I have a week ending date in Cell D6.
I then want to check if either of the dates B8 and C8 fall within the range of "D6-6" and D6.
Any help with a formula would be appreciated.
Thanks in anticipation.
Tony
Reply With Quote
  #2  
Old 02-02-2016, 10:50 PM
xor xor is offline Check if a Date falls within a date range Windows 10 Check if a Date falls within a date range Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

=b8=median(b8,d6,d6-6)
=c8=median(c8,d6,d6-6)
Reply With Quote
  #3  
Old 02-03-2016, 01:55 AM
OTPM OTPM is offline Check if a Date falls within a date range Windows 7 32bit Check if a Date falls within a date range Office 2010 32bit
Expert
Check if a Date falls within a date range
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Xor
Many thanks for your prompt response. Apologies for not making my request clearer. Across the top of my worksheet I have a series of week ending dates (row 6). Where a date in col B or C falls within each of these weekending dates I want to populate that cell with a "0" where I will use conditional formatting to colour each cell that matches.
A sample worksheet is attached for clarity.
Thanks in advance.
Tony
Attached Files
File Type: xlsx Sample Excel Gantt Chart.xlsx (18.2 KB, 5 views)
Reply With Quote
  #4  
Old 02-03-2016, 02:23 AM
xor xor is offline Check if a Date falls within a date range Windows 10 Check if a Date falls within a date range Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Could you please in your file state exactly the results you want returned in D7, E7, F7 ... and D8, E8, F8 etc.

It would help if you give some more examples.
Reply With Quote
  #5  
Old 02-03-2016, 03:07 AM
OTPM OTPM is offline Check if a Date falls within a date range Windows 7 32bit Check if a Date falls within a date range Office 2010 32bit
Expert
Check if a Date falls within a date range
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Xor

Please see revised sample Worksheet.

Thanks

Tony
Attached Files
File Type: xlsx Copy of Sample Excel Gantt Chart.xlsx (18.6 KB, 4 views)
Reply With Quote
  #6  
Old 02-03-2016, 03:48 AM
xor xor is offline Check if a Date falls within a date range Windows 10 Check if a Date falls within a date range Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Sorry but I have no solution.
Reply With Quote
  #7  
Old 02-03-2016, 04:22 AM
OTPM OTPM is offline Check if a Date falls within a date range Windows 7 32bit Check if a Date falls within a date range Office 2010 32bit
Expert
Check if a Date falls within a date range
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Xor
Many thanks for Trying.
Tony
Reply With Quote
  #8  
Old 02-03-2016, 09:11 PM
mikec mikec is offline Check if a Date falls within a date range Windows XP Check if a Date falls within a date range Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2012
Posts: 30
mikec is on a distinguished road
Default dates in a range

I'm not sure I have fully understood your problem but have a look at Book1.xlsx attached
Attached Files
File Type: xlsx Book1.xlsx (9.5 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check if a Date falls within a date range Filter by a Month that falls within a date range MattG1225 Excel 2 12-03-2015 07:44 AM
Check if a Date falls within a date range MS Project Date Range Issue appelguy@gmail.com Project 2 10-31-2015 11:52 AM
Formula for sumifs with less than a date range lynchbro Excel 6 04-15-2015 01:18 PM
HELP: Return a value with a date that falls between two other dates hionman Excel 5 11-12-2014 09:56 AM
Check if a Date falls within a date range Date Range Prompt MikeWooZ Excel 6 12-04-2011 02:10 PM


All times are GMT -7. The time now is 01:35 AM.


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