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

Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list