Hello,
i would like my vba to check Dates on my worksheet if they are far away from each other but i seem to get an error in my formula.
this is what it looks like:
If ((Workday(Range("$E$"),1)-Workday(Range("$G$"),1))*Worksheet("ignore").Range("C20"))>Range("$F$") then
msgbox("test")
end if...