+ Reply to Thread
Results 1 to 4 of 4

Formula to Return Date Once Value Falls Below Criteria in Excel

  1. #1
    Registered User
    Join Date
    05-22-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Formula to Return Date Once Value Falls Below Criteria in Excel

    Afternoon Excel whizzes!

    I have a sheet that tracks inventory by customer every day over several months. I am trying to figure out the most recent date that an account has "closed" (defined as going to 0) its inventory.

    Untitled.png

    I know I need to index the dates, but can't figure out exactly how to setup the criteria such that the formula returns the most recent date an account has closed. Please let me know if you need further clarification! Thank you!
    Attached Files Attached Files
    Last edited by Hodlor; 05-22-2019 at 05:37 PM.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Formula to Return Date Once Value Falls Below Criteria in Excel

    Hi

    Try in K3 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-22-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Formula to Return Date Once Value Falls Below Criteria in Excel

    Jose, that seems to have worked perfectly. I have no idea why, but am quite amazed. Thank you!

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Formula to Return Date Once Value Falls Below Criteria in Excel

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Thanks.

+ 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. Replies: 2
    Last Post: 04-26-2017, 08:06 AM
  2. HELP: Return a value with a date that falls between two other dates
    By hionman in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-18-2014, 08:01 AM
  3. Replies: 3
    Last Post: 08-22-2014, 05:07 AM
  4. [SOLVED] Looking for formula to return a date that falls between 2 dates
    By cobo1981 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2014, 01:12 PM
  5. Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  6. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 AM
  7. Return a specified date when it falls within a range....
    By Nokose451 in forum Excel General
    Replies: 1
    Last Post: 01-16-2006, 06:10 PM

Tags for this Thread

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