+ Reply to Thread
Results 1 to 9 of 9

Formula to find second latest date.

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    53

    Formula to find second latest date.

    Hi,

    I have 3 dates in column A.

    A1= 2/12/2015
    A2=2/13/2015
    A3=2/16/2015

    I have used Small & Large formula to get the earliest and latest Dates in another sheet.

    But i am unable to get the date which is in cell A2.

    Can anyone help?

    Thanks,
    Netaji

  2. #2
    Forum Contributor
    Join Date
    02-15-2015
    Location
    Cecoslovacchia
    MS-Off Ver
    365 personal
    Posts
    100

    Re: Formula to find second latest date.

    Try:
    =large(a1:a3;2)

  3. #3
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Formula to find second latest date.

    Hi Gerry,

    I have tried that solution too,

    It is not working.


    Thanks

  4. #4
    Forum Contributor
    Join Date
    02-15-2015
    Location
    Cecoslovacchia
    MS-Off Ver
    365 personal
    Posts
    100

    Re: Formula to find second latest date.

    Hello Netaji
    what do you mean for second latest date?
    es. today is 2/16/2015 serial number 42051
    than I have a data set
    42050
    42047
    42048
    42004
    41025
    so the the second latest day means the second large day
    and in thi exaple the second largest is 42047
    maybe you need to somenthings else?
    let me know!

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,244

    Re: Formula to find second latest date.

    Quote Originally Posted by GerryZucca View Post
    Try:
    =large(a1:a3;2)
    Agree this should work. Perhaps change ; to ,...
    =large(a1:a3,2)


    If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Formula to find second latest date.

    Thanks for reply FDI.

    Yes i noticed that typo.
    The problem is i have formatted the values to date.
    You can just copy and paste the values i have given in the thread.
    It is not working.

    Thanks,

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Formula to find second latest date.

    Hello Ntaji,

    The formula: =Large(a1:a3,2) as provided by FDibbins, works for me. Are you sure about your formatting, and that you do not have any leading or trailing spaces, which may occur if you have a cell formatted as "Text".

    Alternatively, as FDibbins suggested,

    Attach a sample of your Workbook.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  8. #8
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Formula to find second latest date.

    Yes I got it.

    There was a space.

    Thanks for all your support.

    I am relieved now.

    Thanks again to all those who spent time on the solution.


    Netaji

  9. #9
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Formula to find second latest date.

    Hi Ntaji,

    Thank you for the feedback, glad we could help.

    Regards.

+ 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: 9
    Last Post: 12-21-2014, 06:29 PM
  2. [SOLVED] Find latest date when the name appeared either formula or vba multiple sheets
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2014, 08:24 PM
  3. [SOLVED] Formula to find the latest date of a specified occurance
    By happyhorse in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2013, 12:37 PM
  4. Replies: 1
    Last Post: 04-04-2012, 08:21 AM
  5. [SOLVED] Find latest date for each row
    By scuba79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2005, 06:05 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