+ Reply to Thread
Results 1 to 4 of 4

Maximum and Minimum between two dates

  1. 02-13-2015, 12:56 AM #1
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Maximum and Minimum between two dates

    Hello Friends

    I want to find the Maximum and minimum values for the given dates.

    Attacehd file name : <Maximum and minimum in date range.xlsx>
    Attached file version : 2010

    thanks

    thilag
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-13-2015, 01:07 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Maximum and Minimum between two dates

    =MAX(IF((A1:A86>=E5)*(A1:A86<=F5),(B1:B86)))
    =MIN(IF((A1:A86>=E5)*(A1:A86<=F5),(B1:B86)))
    Try this array formulas
    since it is array formulas confirm with Shift+Ctrl+Enter
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 02-13-2015, 01:24 AM #3
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Maximum and Minimum between two dates

    Dear Siva

    Perfect solution

    thanks

    thilag
    Reply With QuoteRegister To Reply
  4. 02-13-2015, 01:26 AM #4
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Maximum and Minimum between two dates

    You are welcome and thanks for adding reputation
    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. [SOLVED] Sum minus up to a maximum and a minimum
    By Rompetelo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2013, 03:58 AM
  2. [SOLVED] Getting minimum and maximum dates from a variable length range
    By ianbhenderson73 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-13-2013, 12:25 PM
  3. Minimum - maximum dates/times, If function, Parenethesis'
    By Atlanticja in forum Excel General
    Replies: 3
    Last Post: 10-17-2012, 03:31 AM
  4. Maximum and Minimum
    By lurchybold in forum Excel General
    Replies: 6
    Last Post: 10-13-2010, 11:04 AM
  5. Maximum & Minimum Dates based on Condition
    By figs in forum Excel General
    Replies: 3
    Last Post: 08-20-2008, 09:43 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