Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

NETWORKDAYS

Copper Contributor

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!

5 Replies

@Rog778 

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

HansVogelaar_0-1701641180522.png

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

@Rog778 

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

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

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

@Rog778

NETWORKDAYS excludes weekend days (Saturday and Sunday) from the count.