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.