Hi!

Columns A and B both have dates entered. Col A is a start date and Col B is
an end date.

I want the user to filter using a combination of the two. For example...
I want to show all lines of data that have dates that fall between 1/1/10
and 5/5/10. That could mean that the start date or the end date falls within
this range. So even if Col A starts at 12/20/09, but in Col B, it is ends on
1/15/10, it should still show this line of data.

can you help with a formula or filter to achieve this combo? I think it
would be an "OR" statement of some kind possibly since it doesn't need to
meet both Col criteria, just 1 in order to be shown.

Thanks! R