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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 01:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com