+ Reply to Thread
Results 1 to 5 of 5

How to find if a date falls between 2 dates

  1. #1
    JHL
    Guest

    How to find if a date falls between 2 dates

    I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
    result is not right. Any thoughts?

  2. #2
    Chip Pearson
    Guest

    Re: How to find if a date falls between 2 dates

    Try

    =IF(AND(A1>=DATE(2005,1,1),A1<DATE(2005,2,1)),"yes","no")


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "JHL" <JHL@discussions.microsoft.com> wrote in message
    news:42D4A997-0B8E-4739-9743-088C5C4880C2@microsoft.com...
    > I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes",
    > "no") and the
    > result is not right. Any thoughts?




  3. #3
    bpeltzer
    Guest

    RE: How to find if a date falls between 2 dates

    Embed the Date function to convert from dates people understand to what Excel
    uses: =if(and(cell>=date(2005,1,1),cell<date(2005,2,1)),"yes","no")
    --Bruce

    "JHL" wrote:

    > I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
    > result is not right. Any thoughts?


  4. #4
    JE McGimpsey
    Guest

    Re: How to find if a date falls between 2 dates

    One way:

    =IF(AND(cell>=DATE(2005,1,1),cell<DATE(2005,2,1)),"yes","no")

    In article <42D4A997-0B8E-4739-9743-088C5C4880C2@microsoft.com>,
    JHL <JHL@discussions.microsoft.com> wrote:

    > I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
    > result is not right. Any thoughts?


  5. #5
    Bob Phillips
    Guest

    Re: How to find if a date falls between 2 dates

    =AND((A1>=--"2005-01-01")),(A1<--"2005-02-01)"))

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "JHL" <JHL@discussions.microsoft.com> wrote in message
    news:42D4A997-0B8E-4739-9743-088C5C4880C2@microsoft.com...
    > I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and

    the
    > result is not right. Any thoughts?




+ 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