Sort the dates in Col A descending and use this formula:

=MATCH(B1,A1:A4,-1)

It gives 2 as an answer (second date;19-Nov-2006).

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"tkraju via OfficeKB.com" <u16627@uwe wrote in message news:6d59c488fea70@uwe...
| Col a............... Col B
|
| 27-Aug-2005 ..................03-Mar-2006
| 10-Feb-2006
| 19-nov-2006
| 25-Jan-2007
|
| I am looking for a function that gives cell address in range A1:A4 ,date that
| is(nearest) greater than B1 date.
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.a...excel/200702/1
|