+ Reply to Thread
Results 1 to 4 of 4

Finding minimun value based on date less than today

  1. 10-26-2018, 10:47 AM #1
    windme
    windme is offline
    Forum Contributor
    Join Date
    11-22-2003
    Location
    Newport, Rhode Island
    MS-Off Ver
    2021
    Posts
    154

    Finding minimun value based on date less than today

    Hello everyone,
    Using excel 2013

    looking for minimum value in A2:E2 only if the dates(A1:E1) are less than today (10/26/18).

    In the sample worksheet the minimum should be 1 (which occurred on 10/22/18 and 10/24/18), not 0 in E2 because the date is equal to today.

    the formula that I made in G2 returns a value of #VALUE!

    Looking for help in writing the formula to return a 1 in the example.

    Mike
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-26-2018, 10:51 AM #2
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Finding minimun value based on date less than today

    Get rid of the ,0 then confirm the formula with Ctrl Shift Enter.
    Reply With QuoteRegister To Reply
  3. 10-26-2018, 11:08 AM #3
    windme
    windme is offline
    Forum Contributor
    Join Date
    11-22-2003
    Location
    Newport, Rhode Island
    MS-Off Ver
    2021
    Posts
    154

    Re: Finding minimun value based on date less than today

    Thanks 63falcondue, that fixed it.
    Reply With QuoteRegister To Reply
  4. 10-26-2018, 11:10 AM #4
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Finding minimun value based on date less than today

    You're welcome. Happy to help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding a folder with today's date
    By preciouslife73 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2016, 09:06 AM
  2. Formula to figure out the percent up to date based on a date vs. today's date
    By rwelker in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2015, 02:36 PM
  3. [SOLVED] Finding duration between today and the last date entered
    By RJL3313 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-04-2015, 03:25 PM
  4. minimun date & maximum date from column
    By farrukh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-16-2013, 09:22 AM
  5. Finding the nearest date in a column with reference to today
    By lenare in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2013, 10:51 AM
  6. Finding the closest future date from Today from a list of dates
    By maharg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2008, 09:45 AM
  7. Finding Average if today's date has arrived
    By windme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2006, 03:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1