Network days returning negative number

GoGophers22

Back again to ask for some wonderful assistance. Formula works great, except for 1 value it's negative - I am completely lost as to why. Double checked if formula consistent, and it is. So NO CLUE. Any thoughts??

=IFERROR(NETWORKDAYS([IRB Submision Date]@row, [IRB Approval Date]@row), ""

Malaina Hudson

It looks like the formula is working correctly. Your approval date is in the past from your submission date. Submission is 6 Dec 2020 and approval is 25 Mar 2020. Should your submission date have been 6 Dec 2019?

Malaina Hudson

It looks like the formula is working correctly. Your approval date is in the past from your submission date. Submission is 6 Dec 2020 and approval is 25 Mar 2020. Should your submission date have been 6 Dec 2019?

GoGophers22

Yup, that's it. Sheesh, I must need more caffeine. Thank you!!!

Malaina Hudson

@GoGophers22 More caffeine is good. May I recommend Death Wish Coffee? It's one of my favorites.