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 a...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Dec 03, 2023

Rog778 

What formula are you using? I cannot reproduce your results:

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

      • Rog778's avatar
        Rog778
        Copper Contributor
        Dec 03, 2023
        In you picture you posted =NETWORKDAYS would be in cells C2, C3 etc
        That's what I don't understand, all it does is calculate the days between two dates, in this your picture A2 B2 and it's still getting then wrong

Resources