+ Reply to Thread
Results 1 to 4 of 4

Help with Dates between function

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    USA
    MS-Off Ver
    Mac 2011
    Posts
    13

    Help with Dates between function

    I need some help with what should be a simple formula, but I just can't get it to work.

    I have four sets of dates, and I need a IF function to determine if a specified date falls between one of those dates.

    My four sets of dates:

    D1 , D2

    D3, D4

    D5, D6

    D7, D8

    The date I want to check is A1, So check if A1 falls between d1,d2 or d3,d4 or d5,d6 or d7,d8

    I can manage checking if the date falls between one set of dates, but I get a error message, or too many arguments message when trying together.

    If you have the time, I really appreciate the help.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Help with Dates between function

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


    Replace the red part of the formula, for getting the result that you want formula shows.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    01-28-2014
    Location
    Turkey
    MS-Off Ver
    Excel 2013
    Posts
    159

    Re: Help with Dates between function

    Can you attach a sample for this problem ?

  4. #4
    Registered User
    Join Date
    09-03-2014
    Location
    USA
    MS-Off Ver
    Mac 2011
    Posts
    13

    Re: Help with Dates between function

    Fotis,

    I was close, but you solved it for me, Thanks for saving me a lot off time.

    Cheers,

    R

+ 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. [SOLVED] What If Function Using Two Dates...
    By DMA-Pacific in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2014, 02:14 AM
  2. [SOLVED] Subtracting MONTH Function from another MONTH Function not working for Fiscal dates
    By amartin575 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2013, 10:52 AM
  3. COUNTIF function with Dates & due dates.
    By kcowper in forum Excel General
    Replies: 3
    Last Post: 03-10-2011, 12:51 AM
  4. Blank function/Null function for missing dates
    By knowledgeiskey in forum Excel General
    Replies: 2
    Last Post: 05-21-2010, 05:39 PM
  5. if function for dates
    By corinne.lewis in forum Excel General
    Replies: 1
    Last Post: 02-28-2008, 01:07 PM

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