+ Reply to Thread
Results 1 to 4 of 4

Date search, this one is a doozy

  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    dallas, tx
    MS-Off Ver
    Excel 2007
    Posts
    36

    Date search, this one is a doozy

    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.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date search, this one is a doozy

    Hi,

    Depending on your definition of crossover how about in C1 copied down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Date search, this one is a doozy

    If you are referring to one date range overlapping the next one then this might be what you want

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    12-10-2013
    Location
    dallas, tx
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Date search, this one is a doozy

    Quote Originally Posted by newdoverman View Post
    If you are referring to one date range overlapping the next one then this might be what you want

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This one came pretty close. I modified it to allow > and =:
    =IF(AND(B13>=A14,A14<>" "),"ALERT","OK")

    Let's see how it goes, thanks!
    Last edited by Scalpel4; 12-11-2013 at 11:38 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. search code-date then copy name-date-time to another sheet
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2013, 02:25 AM
  2. Real DOOZY VBA code needed.... help!
    By luccib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2012, 06:38 PM
  3. This is a doozy...
    By Jen Kulak in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2005, 08:06 AM
  4. Doozy - tracking multiple sheets
    By blarrg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2005, 12:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1