Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate 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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate next appt. day
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate next appt. day
Or, if you need to match a date with a name:
=MIN(IF((B1:B10TODAY())*(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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate a cube root | New Users to Excel | |||
How do I calculate hours in Excel | New Users to Excel | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |