Formula not working

azerty64 ✭✭

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

Screenshot 2023-02-20 10.04.47.png

Hello,

can you explain this error to me?

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

Thank you

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Nick Korna ✭✭✭✭✭✭

  02/20/23 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!

  0 · Share on FacebookShare on Twitter

Answers

• 

  Nick Korna ✭✭✭✭✭✭

  02/20/23 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!

  0 · Share on FacebookShare on Twitter
• 

  azerty64 ✭✭

  02/20/23

  https://community.smartsheet.com/discussion/comment/363154#Comment_363154

  oh ok that makes sense...thank a lot !

  Have good day !

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list