Network days returning negative number
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), ""
Best Answer
-
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?
Answers
-
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?
-
Yup, that's it. Sheesh, I must need more caffeine. Thank you!!!
-
@GoGophers22 More caffeine is good. May I recommend Death Wish Coffee? It's one of my favorites.
Help Article Resources
Categories
Check out the Formula Handbook template!
