Forum Discussion
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...
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
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.