Thread: Check if a Date falls within a date range
View Single Post
 
Old 02-02-2016, 02:05 PM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
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