https://bugs.documentfoundation.org/show_bug.cgi?id=166193
Bug ID: 166193
Summary: NETWORKDAYS function is broken
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kirsch...@gmx.de
Description:
I generated a new Calc document and tried the example from wiki [1] or recent
html help [2]. In the end I got an "Err:259".
Cell input is:
=NETWORKDAYS("2020-01-01"; "2020-12-31"; {"2020-01-01", "2020-04-10",
"2020-04-13", "2020-05-08", "2020-05-25", "2020-08-31", "2020-12-25",
"2020-12-28"})
The same happens if I try the DATE funftion as mentioned in the html help.
[1]
https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS/en
[2]
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_networkdays.html?DbPAR=CALC#bm_id3151254
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: default;
VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL threaded
Steps to Reproduce:
1. generate a new Calc document
2. go to any cell an input:
=NETWORKDAYS("2020-01-01"; "2020-12-31"; {"2020-01-01", "2020-04-10",
"2020-04-13", "2020-05-08", "2020-05-25", "2020-08-31", "2020-12-25",
"2020-12-28"})
3. hit enter
Actual Results:
"Err:259"
Expected Results:
8 specified holiday dates, and default 5-day workweek: 254
Reproducible: Always
User Profile Reset: No
Additional Info:
calculate correct workdays for given period of time
--
You are receiving this mail because:
You are the assignee for the bug.
