+ Reply to Thread
Results 1 to 6 of 6

find the date close to that request

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    find the date close to that request

    Hello I need to find the start and end dates of a chosen period.
    In D3 insert start date to end date chosen E3 choice

    In F3 using a formula (that is not working properly) I want to find the first date of column A corresponding to day month year inserted in D3.
    In G3 (although the current formula returns the correct data) I want are in column A day month year of the date entered in E3
    If the date on A is not in search of those that must be taken close
    example, if I enter into D3 01/05/2016 and in column A on the first day is the 04/05/2016 you will have to report F3 04/05/2016
    The same thing goes for the cell G3 return the last day in the month column A chosen E3
    Thank you very much
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: find the date close to that request

    Try these

    F3: =INDEX(A3:A20,MATCH(TRUE,INDEX(A3:A20>=D3,0),0))
    G3: =LOOKUP(E3,A3:A20)

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,908

    Re: find the date close to that request

    Or try this ...

    F3: =MIN(IF(A3:A536>=D3,A3:A536,""))

    G3: =MAX(IF(A3:A536<=E3,A3:A536,""))

    Enter with Ctrl+Shift+Enter.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: find the date close to that request

    Quote Originally Posted by Phuocam View Post
    F3: =MIN(IF(A3:A536>=D3,A3:A536,""))

    G3: =MAX(IF(A3:A536<=E3,A3:A536,""))
    No need for the blanks "".

    =MIN(IF(A3:A536>=D3,A3:A536))

    =MAX(IF(A3:A536<=E3,A3:A536))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: find the date close to that request

    Fantastic, thanks to all work

    I used the proposed Phuocam no "" as suggested by Tony Valko.
    Thanks again to the next.

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: find the date close to that request

    You're welcome. Thanks for the feedback!

+ 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] find form a box and find in another close workbook
    By salazarcl.17 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2016, 11:00 AM
  2. Request for Formula to find out True Or False
    By umesh.dange in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 09:43 AM
  3. [SOLVED] Determine date based on request date meanwhile falls on particular days
    By Hikari in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-18-2013, 09:37 AM
  4. Replies: 1
    Last Post: 09-28-2012, 08:52 AM
  5. [SOLVED] Macro Request to find and remove repated value within the cell
    By ganeshinscribe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2012, 08:27 AM
  6. Excel Find & Replace Macro Request Help
    By ganeshinscribe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2012, 09:21 AM
  7. Where do I find the Payment Request Wizard in Outlook?
    By nonprofitgirl in forum Excel General
    Replies: 0
    Last Post: 05-18-2005, 07:06 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