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


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


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


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


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


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