Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Check if a Date falls within a date range
Register FAQ

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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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, 11 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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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, 10 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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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, 10 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:25 PM.

Contact Us - Privacy Statement - Top

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