Results 1 to 6 of 6

Thread: Lookup Start Date And End Date Range For Specific Date Using Formula

  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0

    Lookup Start Date And End Date Range For Specific Date Using Formula

    Hi!
    In column (A) some dates
    I want when you enter a date to be brought start date and the end date for this period
    I hope to have a solution by the formula
    Attached Files Attached Files
    Last edited by mahmoud-lee; 06-14-2013 at 05:45 AM.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    D27=INDEX($A$1:$A$60,MATCH(C27,$A$1:$A$60))
    E27=SMALL(INDEX($A$1:$A$60,MATCH(C27,$A$1:$A$60)): $A69,2)
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    I am very sorry
    No start date is also working
    But the end date works great
    Well I found the right solution
    Attached Files Attached Files

  4. #4
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    But I need you anything else
    I need
    Is this the time (15:03:34) is located between the time (10:00:00) to the time 17:00:00 ?

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    The formula I posted works perfectly for both the start date and the end date. This can be replicated for finding start time and end time range also.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  6. #6
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    I want to know
    Is this the time (15:00:00) is located between the (10:00:00) (17:00:00)
    If you are located, including writing (1) and if you do not exist is written (0)

Similar Threads

  1. Select Sheets For Specific Date By Clicking On A Calendar
    By peter renton in forum Excel Help
    Replies: 10
    Last Post: 05-17-2013, 01:57 PM
  2. Replace Incorrect Date In Cell To Another Valid Date
    By DARSHANKmandya in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 03-21-2013, 09:27 PM
  3. Date Format From Start Day To End Day
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 03-10-2013, 02:07 PM
  4. Replies: 17
    Last Post: 12-18-2012, 04:15 PM
  5. Sum Ifs Formula needed with Max Date range
    By trankim in forum Excel Help
    Replies: 2
    Last Post: 09-19-2012, 09:50 AM

Posting Permissions

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