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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65K Get Help
- 442 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 149 Just for fun
- 70 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
