Forum Discussion

Rog778's avatar
Rog778
Copper Contributor
Dec 03, 2023

NETWORKDAYS

Hi, I have a Networkdays function error that is confusing me. Number of days calculated are wrong, eg
04/01/2024 07/04/2025 2 Days
14/01/2024 24/01/2024 15 Days

There is a column of 11 rows Some are correct Some are not!
Any advice? With such a simple function there doesn't seem much to go wrong or test!

excel
Formulas and Functions
    • Rog778's avatar
      Rog778
      Copper Contributor
      Dec 03, 2023
      My bad suppose to be
      04/01/2024 07/01/2024 2 Days
      14/01/2024 24/01/2024 15 Days

      Function is just =NETWORKDAYS
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Dec 03, 2023

        Rog778 

        Normally, =NETWORKDAYS should cause a #NAME! error.

        Does your workbook contain a defined name NETWORKDAYS? You can check this in Formulas > Name Manager.

Resources