try:

=INDEX(A3:A500,MATCH(TODAY(),A3:A500,0)-1)

HTH

"SteveC" wrote:

Hi, in Column A I have dates A3:A500. In one of those cells -- it could be
almost any one -- is today's date -1. So let's say for the data range i'm
using, the today's date -1 is in cell A300, and its 2/14/2007.

How do I pull in the date value immediately above in cell a299? It's not
necesarily 2/13/2007 -- it could be 2/10/2007 or whatever...

thanks... not sure what function to use or to start with. Thanks very much
for your help.

SteveC