Formula not working

azerty64 ✭✭
edited 02/20/23 in Formulas and Functions


can you explain this error to me?

The formula returns me the value 0 for a project that lasts one day

Thank you


Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @azerty64,

    March 26th is a Sunday, so it is not counted as a working day - hence the NETWORKDAYS formula gives this result while working fine for the April 27th (a Thursday) line above.

    Hope this explains it for you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!