Calculate next appt. day
Try:
=MIN(IF(A1:A10TODAY(),A1:A10))
enter using CTRL+SHIFT+ENTER
HTH
JG
"NUMBnut" wrote:
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.
|