Formula to find second latest date.

1. 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. Re: Formula to find second latest date.

Try:
=large(a1:a3;2)

3. Re: Formula to find second latest date.

Hi Gerry,

I have tried that solution too,

It is not working.

Thanks

4. 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. Re: Formula to find second latest date.

Originally Posted by GerryZucca
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.

6. Re: Formula to find second latest date.

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. 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

8. Re: Formula to find second latest date.

Yes I got it.

There was a space.

I am relieved now.

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

Netaji

9. Re: Formula to find second latest date.

Hi Ntaji,

Thank you for the feedback, glad we could help.

Regards.

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

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