Teethless,
Your formula returned a #N/A. Not sure why. I used Mike's
solution. Thanks for your help.

Mike

"Teethless mama" wrote:

Sort data in Descending order

=INDEX(G9:G20,MATCH(I3,G9:G20,-1))


"Mike K" wrote:

Oh Wise Ones,
I'm kinda embarrassed by this one but I can't get it
to work. If I have =NOW() in I3 and in G9:G20 I have these dates:
2/03/07
3/03/07
4/03/07
5/03/07
......
1/03/08

Shouldn't (in J3) =MATCH(I3,G9:G20,1) return 4/01/07? It returns 2/02/2008 I
need the get the closest to but more than todays date from that column.
Please help

Thanks,
Mike