| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WORKDAY Function in an IF statement
I have created a spreadsheet for my work where I will store some
financial data. What I want to create is a form of alert that notifies me on a day a report needs to be sent out - 2, i.e assuming the report needs to be sent on 25/01, and that date has been entered in the spreadsheet, notify me two days before that. I have tried the following formula but is does not work: IF((H10=WORKDAY, -2), "SEND REPORT", "FINE")). Any ideas/suggestions? Many thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY Function in an IF statement
=IF(TODAY()=WORKDAY(H10,-2), "SEND REPORT", "FINE")
-- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message oups.com... I have created a spreadsheet for my work where I will store some financial data. What I want to create is a form of alert that notifies me on a day a report needs to be sent out - 2, i.e assuming the report needs to be sent on 25/01, and that date has been entered in the spreadsheet, notify me two days before that. I have tried the following formula but is does not work: IF((H10=WORKDAY, -2), "SEND REPORT", "FINE")). Any ideas/suggestions? Many thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY Function in an IF statement
Worked like a treat!Thanks!
Bob Phillips wrote: =IF(TODAY()=WORKDAY(H10,-2), "SEND REPORT", "FINE") -- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message oups.com... I have created a spreadsheet for my work where I will store some financial data. What I want to create is a form of alert that notifies me on a day a report needs to be sent out - 2, i.e assuming the report needs to be sent on 25/01, and that date has been entered in the spreadsheet, notify me two days before that. I have tried the following formula but is does not work: IF((H10=WORKDAY, -2), "SEND REPORT", "FINE")). Any ideas/suggestions? Many thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Workday function | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Linear Mode
