Hi,

Replace A1:A6 by your range

=MIN(IF(ISNUMBER(MATCH(A1:A6,N(A1:A6=TODAY())*A1: A6,0)),A1:A6))



"LaDdIe" a écrit dans le message de groupe de
discussion : ...
Hello

I have a range of dates in col A formated as 'ddd dd-mm-yyyy' the range is
named 'DataSheetDate', I would like a Macro that will find a date = today's
date and select the the cell offset(0,1).

Thanks.