Alright, here's a brain bender.
I have two columns with dates, like so:
8/24/2013 8/25/2013
8/21/2013 9/1/2013
9/8/2013 9/8/2013
9/8/2013 9/8/2013
9/12/2013 9/12/2013
9/14/2013 9/14/2013
9/17/2013 9/29/2013
10/11/2013 10/11/2013
10/12/2013 10/31/2013
10/13/2013 10/14/2013
10/15/2013 10/17/2013
This is a start date and end date. I need to write a formula for Column C to see if any of these date ranges cross over. And the really hard part is, the dates are in order, but the overlaps may not be in the row above or below, it may be a few rows down, so it needs to check the entire column. :-S
Usually I'm the guy helping everyone else with this stuff, sorry to make my first post such a killer.
Bookmarks