Use LARGE

=LARGE(A2:A500,2)

will return the second highest number which would be the equivalent of the
second most recent date assuming that the dates are numerical excel dates
and not text strings

--


Regards,


Peo Sjoblom

"carol" wrote in message
...
Hi,

I know that the 'MAX' formula can be used to look into a range and pick
out
the most recent date.

Is it possible to use this formula to pick out the second most recent
date?

Thanks for youe help.

Carol