You have not said what is in the various ranges referenced by your
formula. Assuming that you have a range of sale dates, =MAX(dateRange)
is the date of the most recent sale and =LARGE(dateRange,2) is the date
of the second most recent sale.

Jerry

Ben wrote:

I have the following formula to extract the date of the
most recent sale from a list.

=INDEX(SALES,MATCH(TODAY(),SALE_DATE,1),MATCH
(O4,O13:T13,0))

I would like to build another formula to extract the next
recent sales date entry. This entry may have the same
date as the most recent in the list. I have tried
entering -1 in various places, only to retrive errors or
yesterdays date with no data (in the case there was no
sale yesterday).

Does anyone have any ideas?

Thank you.