Index/Match Help
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.
|