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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.