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

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

Use the LARGE function for that. For example (change the range to suit you
conditions)...

=LARGE(A1:Z3,2)

Rick


"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

Use the Large formula

=Large(A1:A2, 2)

Will return the second largest value in cells A1:A10
--
HTH...

Jim Thomlinson


"carol" wrote:

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