Issue networkdays value in google spreadsheet

Question

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

player0 · Answer

looks like a bug but here is some quick workaround:

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

José Luis López Navas · Answer

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.

Issue networkdays value in google spreadsheet

2 Answers