View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MoonBlosm MoonBlosm is offline
external usenet poster
 
Posts: 3
Default Date Range within a date range - try again

I have a start and stop date. I want to see if any part of that start/stop
range falls within another date range.

Start: 9/15/09
End: 10/1/09

Date range to search: 8/31/09 - 9/30/09
next range 9/30/09 - 10/31/09

The answer would be true for both as at least one day of the start and stop
range fall in the ranges to search.

I posted this earlier, but can not find the post, so I am trying again.

This has me stumped.

Thanks in Advance