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

  • Malaina Hudson
    Malaina Hudson ✭✭✭✭✭
    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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!