Hi guys/gals


I have in column A a list of dates in descending order. Let=B4s say I
have in cell c1 a date, I need in cell D1 the row , in A, which has
that date and, in case it doesn=B4t exist, it should give the row of the
next following date below (closest "match" to date in c1).

I tried:
match(datenumber(TEXT(C1,"dd/mm/yy")),index(A1:A1813,,0),-1) that works
fine when the date exist but error if not.

Thanks in advance,
mika