=(IF(AND(ISDATE INCORRECT ARGURMENT - HELP
I am gettng an Incorrect Arguement with the following formula and can't figure out how to fix it.
=(IF(AND(ISDATE([email protected]), ISDATE([email protected])), NETWORKDAYS([email protected], [email protected]) < 0, "1", NETWORKDAYS([email protected], [email protected])))
0
Answers
Hi Hillary
Try removing the quotes from the number 1
No dice :( -
=(IF(AND(ISDATE([email protected]), ISDATE([email protected])), NETWORKDAYS([email protected], [email protected]) < 0, 1, NETWORKDAYS([email protected], [email protected])))
Hi there @Hillary Walker ,
One reason you will be receiving this error, is that you formula opens with a bracket. It should instead be =IF, rather than =(IF.
Furthermore, I see you are using "ISDATE". Is this a requirement of the Formula? Will there be other values, other than a date, in your Date columns?
Although I'm unsure on the use case of your Formula, I was able to make a more logically correct version of the same Formula: =IF(NETWORKDAYS([email protected], [email protected]) < 0, 1, NETWORKDAYS([email protected], [email protected]))
If I have misunderstood your issue, or if you are still facing issues with your Formula, are you able to provide a screenshot of your Sheet (Whilst hiding any sensitive information), and let me know what your Formula should do?
Regards
Sean