WORKDAY Function in an IF statement

[vkocheilas]

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

 

[Bob Phillips]

=IF(TODAY()>=WORKDAY(H10,-2), "SEND REPORT", "FINE")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[vkocheilas]

Worked like a treat!Thanks!

=IF(TODAY()>=WORKDAY(H10,-2), "SEND REPORT", "FINE")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)