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

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:

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

Links to your other posts:
https://www.microsoft.com/office/com...a-3a574dd06b38

https://www.microsoft.com/office/com...1-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.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MoonBlosm" wrote:

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