Forum Discussion
How to add an "IF" date rule to a current formula?
I have a formula that is already written with a couple of "IF" rules and I am wanting to add to it. The current formula is =IIf([HW only]=No,[rent]*0.07613,IIf([state]="mo",[rent]*0.07613,0)) This...
Hi Jamie,
Do you mean VBA function (IIF) or worksheet function (IF)? With latest use
DATEVALUE(”10/1/2017”)
instaed of text to compare.
It's a VBA function.
In VBA date constant looks like
#10/1/2017#
