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.
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.
Use
=MIN(IF(A1:A20>TODAY(),A1:A20))
which is an array formula, so commit with Ctrl-Shift-Enter
--
HTH
RP
"NUMBnut" <[email protected]> wrote in message
news:[email protected]...
> 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.
Try:
=MIN(IF(A1:A10>TODAY(),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.
Or, if you need to match a date with a name:
=MIN(IF((B1:B10>TODAY())*(A1:A10=C1),G8:G13))
again entered using CTRL+SHIFT+ENTER
where A1:A10 list of names,B1:B10 dates and C1 name to lookup
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks