Use

=MIN(IF(A1:A20TODAY(),A1:A20))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP

"NUMBnut" wrote in message
...
I need a formula that will pick the next appt. day from today in a column.

ex. one client has appts. for 1/9 1/17 and 1/20, and today is 1/12. I
need
it to pull up the 1/17 date as the next appt. day.