# Talk:Documentation/Calc Functions/NETWORKDAYS

(1) Summary. It seems odd to say that holidays can be deducted without mentioning that the working week can be re-defined. Suggest the following replacement text – “Calculates the whole number of working days in a period. Holidays can be specified and the working days in each week can be redefined.”.
(2) Summary. Suggest including the following as a tip – “To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date in quotation marks and use the ISO 8601 notation, for example, "1954-07-20". Avoid using locale dependent date formats such as "07/20/54", the calculation may produce errors if the document is loaded under different locale settings.”.
(3) Returns. Suggest the following re-word – “Returns an integer value which is the number of working days in the given period, excluding defined holidays and weekend days. The start and end dates of the period are counted unless they are defined as holidays or non-work (weekend) days.”
(4) Arguments, StartDate. Suggest the following replacement text – “StartDate is a date (in quotation marks) or a date-time sequence number, or a reference to the cell containing one of those types, which is either the start date or the end date of the period for which the calculation is to be carried out.”
(5) Arguments, EndDate. Suggest the following replacement text – “EndDate is a date (in quotation marks) or a date-time sequence number, or a reference to the cell containing one of those types, which is either the end date or the start date of the period for which the calculation is to be carried out.”
(6) Arguments, Holidays. Might be worth clarifying this paragraph. If using an inline array, then the values are either dates in quotation marks or date-time sequence numbers. Similarly, if providing a cell range, values can be either dates or date-time sequence numbers.
(7) Arguments, Workdays. Need to clarify that this argument can be passed as an inline array of 7 values or as a cell range containing the 7 values.
(8) Arguments, new bullet. Suggest adding the following – “If EndDate is earlier than StartDate, the result is a negative integer; if EndDate is later than StartDate, the result is a positive integer.”.
(9) Arguments, new bullet. It might be worth noting that NETWORKDAYS ignores any time components of the StartDate, EndDate, and Holidays arguments.
(10) Arguments, new bullet. What happens is either StartDate or EndDate is invalid?
(11) Arguments, new bullet. Mention that if Holidays is passed as an inline array, a #VALUE! error results if any entry of that array is not a date or a date-time sequence number. If Holidays is passed as a cell range, then in most cases cells that do not contain a date or a date-time sequence number lying within the relevant period are ignored. However, if a cell contains an error code (such as #NAME?), that error status will be propagated as the result of NETWORKDAYS.
(12) Arguments, new bullet. Mention that if Workdays is passed as an inline array, an Err:502 results if that array is not exactly 7 entries long. Similarly, if a range of cells is passed which comprises less than 7 cells an Err:502 results. If a cell contains an error code (such as #NAME?), that error status will be propagated as the result of NETWORKDAYS. This bullet probably makes the sole existing bullet point redundant.