+ Reply to Thread
Results 1 to 2 of 2

Formula to verify date range

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Sacramento
    MS-Off Ver
    Excel 2007
    Posts
    1

    Formula to verify date range

    Hello
    I am looking for a formula to determine if any date of a date range falls within another range. In cell D2 and E2 i will enter my start and end date, lets say 4/8/2013-4/21/2013. I need to determine if any date within the range in cells A2:B100 fall within the range of 4/8/2013 to 4/21/2013. Would like the result of "YES" or "NO" to be populated in column "C". Thank you for your help.

    Ed

    Column A Column B Column C
    Start Date End Date Result
    3/26/2013 4/11/2013 "YES"
    4/9/2013 6/1/2013 "YES"
    1/4/2013 3/5/2013 "NO"

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Formula to verify date range

    Please Login or Register  to view this content.
    Try this. Hope help.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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