https://bugs.documentfoundation.org/show_bug.cgi?id=100353
Bug ID: 100353
Summary: NETWORDAYS function
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
Help: https://help.libreoffice.org/Calc/NETWORKDAYS
ODF: Definition in ODF - NETWORKDAYS
Summary: Returns the whole number of work days between two dates.
Syntax: NETWORKDAYS( DateParam Date1 ; DateParam Date2 [ ; [ DateSequence
holidays ] [ ; LogicalSequence workdays ] ] )
Returns: Number
Constraints: None
Semantics: Returns the whole number of work days between two dates.
Work days are defined as non-weekend, non-holiday days. By default, weekends
are Saturdays and Sundays and there are no holidays.
The optional 3rd parameter Holidays can be used to specify a list of dates to
be treated as holidays. Note that this parameter can be omitted as an empty
parameter (two consecutive ;; semicolons) to be able to pass the set of
Workdays without Holidays.
The optional 4th parameter Workdays can be used to specify a different
definition for the standard work week by passing in a list of numbers which
define which days of the week are workdays (indicated by 0) or not (indicated
by non-zero) in order Sunday, Monday,...,Saturday. So, the default definition
of the work week excludes Saturday and Sunday and is: {1;0;0;0;0;0;1}. To
define the work week as excluding Friday and Saturday, the third parameter
would be: {0;0;0;0;0;1;1}.
LO Calc works like defined in ODF specification. Formula
=NETWORKDAYS(K2;K2+6;;{1;0;1;0;1;0;1}) works.
Help should reflect 4th parameter.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
