=MIN(IF(rngTODAY(),rng))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"gerrit" wrote in message
...
Hello,
suppose you have a range of dates and you would like to select the nearest
future date. For exemple, range of possible monthly repayment dates goes
from
1st Jan over 1st Feb to 1st December. Today it is 12th Feb so the first
next
possible redemption date should be 1st March. On 24th June, the first
possible redemption date should be 1st July.

My question is, is there anybody who can explain me how to program such a
formula in excel? Many thanks in advance, Gerrit