Search code examples
dateif-statementgoogle-sheets-formulaspreadsheetdays

Issue networkdays value in google spreadsheet


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


Solution

  • 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.