Issue networkdays value in google spreadsheet-CodePudding

I have created the formula = NETWORKDAYS.INTL(E84,F84) and E84 and F84 are same date -> 2022.9.5. if it is the same date in both columns, it shows the value 1 but it shows the value 0.

It worked before but now it doesn't work.

https://docs.google.com/spreadsheets/d/1dY6gwDIjjxUPTU-4v0j1MqF1sq7YCgHLTH040QMQrHU/edit?usp=sharing

CodePudding user response：

if I would need to guess it has something to do with locale setting but here is some quick workaround till someone smarter will figure out why it yields you 0 and not 1:

=IF(A2=B2; 1; NETWORKDAYS(A2; B2))

CodePudding user response：

There was an issue and now it's working properly. Here are more details.

If you refresh the document, you can reload the function with the fix.