=(IF(AND(ISDATE INCORRECT ARGURMENT - HELP

Hillary Walker

I am gettng an Incorrect Arguement with the following formula and can't figure out how to fix it.

=(IF(AND(ISDATE(Complete@row), ISDATE(TATS@row)), NETWORKDAYS(TATS@row, Complete@row) < 0, "1", NETWORKDAYS(TATS@row, Complete@row)))

Kelly Moore

Hi Hillary

Try removing the quotes from the number 1

Hillary Walker

No dice :( -

=(IF(AND(ISDATE(Complete@row), ISDATE(TATS@row)), NETWORKDAYS(TATS@row, Complete@row) < 0, 1, NETWORKDAYS(TATS@row, Complete@row)))

Sean Morgan

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(TATS@row, Complete@row) < 0, 1, NETWORKDAYS(TATS@row, Complete@row))

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