Date Range within a date range - try again

[MoonBlosm]

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

 

[Stefi]

A B C
start end
9/15/09 10/1/09
8/31/09 9/30/09 TRUE
9/30/09 10/31/09 TRUE


Formula in C3:

=OR($A$2>=A3,$B$2<=B3)
fill it down!

Regards,
Stefi

„MoonBlosm†ezt írta:

 

[Luke M]

Links to your other posts
https://www.microsoft.com/office/co...&p=1&tid=cd3071d3-053e-47bd-9b2a-3a574dd06b38

https://www.microsoft.com/office/co...&p=1&tid=2ce9c617-0aa9-4a85-83e1-e816780a1514

Note that if you click on a user name in a post (where is says By: NameHere)
you can click on the name, and then click on "recent posts by this user". Or,
sometimes searching for your user name is a good way to find a "lost" post.