+ Reply to Thread
Results 1 to 3 of 3

Need a formula/s to return the three most recent dates from a list

  1. 07-03-2015, 04:22 AM #1
    john dalton
    john dalton is offline
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Need a formula/s to return the three most recent dates from a list

    Hi I have a list of dates and I am looking to show the three most recent dates.

    Please see attached workbook for deatils.

    Thanks in advance

    John
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-03-2015, 04:28 AM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: Need a formula/s to return the three most recent dates from a list

    With reference to your sample file

    =LARGE($B$4:$B$9,1) in F4: change 1 to 2 and 3 for next two cells (F5/F6)
    Reply With QuoteRegister To Reply
  3. 07-03-2015, 04:31 AM #3
    john dalton
    john dalton is offline
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Need a formula/s to return the three most recent dates from a list

    Much appreciated, reputation added.

    John
    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. text within multiple strings, look @ dates in next column, return most recent date
    By amazingg64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2012, 01:44 PM
  2. How do you return the 5 most recent dates from a list?
    By domcron in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-31-2006, 01:57 PM
  3. Search for most recent date from list of dates
    By Wendell in forum Excel General
    Replies: 1
    Last Post: 06-22-2005, 07:04 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