Select Date in a column

[#1]

Hi all, please help if you can

I need a way to find the second highest value in a date range.

So if this is the Table

Date

17/10/2012

14/10/2012

13/10/2012

11/10/2012

05/10/2012

I would want the formula to return 14/10/2012...

I might be over thinking this but I am not sure how to do this..

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try this: =date(FirstSortedValue( [Date],-[Date],2),'DD/MM/YYYY')

Also make sure your date is really a date and not text. Use the date# function if necessary.

[#3]

Gysbert, thanks for this! it headed me in the right direction... I ended up using this:

=FirstSortedValue(DISTINCT [Date],-[Date],2)