+ Reply to Thread
Results 1 to 2 of 2

Return a specified date when it falls within a range....

  1. #1
    Registered User
    Join Date
    01-16-2006
    Posts
    3

    Exclamation Return a specified date when it falls within a range....

    Hello all. I hope someone can help me figure this one out. So here we go....

    I have a spread sheet that you plug in a date and then enter another date manually. The second date is the on I would like to automate. I need the first date to be complared in a range of dates and then return the effective date.

    Example:
    Entered date - 01/08/2006

    Range Table: Effective:
    01/01/2006 - 01/05/2006 01/05/2006
    01/06/2006 - 01/10/2006 01/10/2006
    01/11/2006 - 01/15/2006 01/15/2006

    I would like it to return the 01/10/2006 effective date for that range. Any help is appreciated.

  2. #2
    Gary''s Student
    Guest

    RE: Return a specified date when it falls within a range....

    Use VLOOKUP:


    If your data is in cols A,B,C and the target is in F1 then
    =VLOOKUP(F1,A1:C3,3,TRUE) will return the desired value.
    --
    Gary's Student


    "Nokose451" wrote:

    >
    > Hello all. I hope someone can help me figure this one out. So here we
    > go....
    >
    > I have a spread sheet that you plug in a date and then enter another
    > date manually. The second date is the on I would like to automate. I
    > need the first date to be complared in a range of dates and then return
    > the effective date.
    >
    > Example:
    > Entered date - 01/08/2006
    >
    > Range Table: Effective:
    > 01/01/2006 - 01/05/2006 01/05/2006
    > 01/06/2006 - 01/10/2006 01/10/2006
    > 01/11/2006 - 01/15/2006 01/15/2006
    >
    > I would like it to return the 01/10/2006 effective date for that range.
    > Any help is appreciated.
    >
    >
    > --
    > Nokose451
    > ------------------------------------------------------------------------
    > Nokose451's Profile: http://www.excelforum.com/member.php...o&userid=30528
    > View this thread: http://www.excelforum.com/showthread...hreadid=501829
    >
    >


+ 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