Documentation/Calc Functions/NETWORKDAYS.INTL

Function name:
NETWORKDAYS.INTL

Category:
Date and Time

Summary:
Calculates the net number of work or business days between two dates. Holidays (or other non-work days) can be specified and the standard workweek can be redefined.

Syntax:
NETWORKDAYS.INTL(StartDate; EndDate[; [Weekend] [; Holidays] ])

Returns:
Returns an integer value which is the number of work or business 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 weekend days.

Arguments:
StartDate is the date (in quotation marks) or a date-time serial 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.

EndDate is the date (in quotation marks) or a date-time serial 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.

Holidays is a list of dates corresponding to holidays that are not to be counted as workdays. This list can be passed as a range of cells containing date-time serial numbers (possibly displayed in a date format). Alternatively, the list can be passed as an inline array containing either date strings (in quotation marks) or date-time serial numbers. If omitted, no holidays are assumed.


 * If either StartDate or EndDate is not a valid date expression, then NETWORKDAYS.INTL reports a #VALUE! error.
 * If StartDate is earlier than EndDate, the result is a positive integer; if StartDate is later than EndDate, the result is a negative integer.
 * NETWORKDAYS.INTL ignores any time components of StartDate and EndDate.
 * If a string is used for the Weekend argument, and that string does not contain exactly seven characters, NETWORKDAYS.INTL reports a #VALUE! error. If the string does contain seven characters, but at least one of those characters is neither a '0' nor a '1', then NETWORKDAYS.INTL reports an invalid argument error (Err:502).
 * If a number is used for the Weekend argument, and that number is not an integer value, then NETWORKDAYS.INTL reports an invalid argument error (Err:502). If the number is an integer value but does not lie in either the range 1 to 7 or the range 11 to 17, then NETWORKDAYS.INTL reports a #VALUE! error.
 * If Weekend is passed as a cell reference and that cell contains an error code (such as #NAME?), that error status will be propagated as the result of NETWORKDAYS.INTL.
 * If Holidays is passed as an inline array, and any entry of that array is not a date or a date-time serial number, then NETWORKDAYS.INTL reports a #VALUE! error.
 * If Holidays is passed as a cell range, then in most cases cells that do not contain a date or a date-time serial 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.INTL.

Details specific to NETWORKDAYS.INTL function
NETWORKDAYS.INTL is inclusive, counting the first and last days of the period (see ).

Related LibreOffice functions:
NETWORKDAYS

NETWORKDAYS_EXCEL2003

ODF standard:
None.

Equivalent Excel functions:
NETWORKDAYS.INTL