Formula not working

azerty64

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

Nick Korna

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!

Nick Korna

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!

azerty64

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

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

Have good day !