Date and Time
Gives the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.
NETWORKDAYS.INTL(StartDate; EndDate[; [Weekend] [; Holidays] ])
Returns an integer value which is the number of workdays between StartDate and EndDate considering Holidays and Weekend (as defined by the parameters) as non-working days.
StartDate is the date or a date sequence number or a reference to the cell containing that date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.
EndDate is the date or a date sequence number or a reference to the cell containing that date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation.
Weekend is an optional parameter – a number or a string used to specify the days of the week that are weekend days and are not considered working days. Weekend is a weekend number or string that specifies when weekends occur. Weekend number values indicate the following weekend days:
Number 1 to 7 for two-day weekends and 11 to 17 for one-day weekends.
|1 or omitted||Saturday and Sunday|
|2||Sunday and Monday|
|3||Monday and Tuesday|
|4||Tuesday and Wednesday|
|5||Wednesday and Thursday|
|6||Thursday and Friday|
|7||Friday and Saturday|
Weekend string provides another way to define the weekly non-working days. It must have seven (7) characters – zeros (0) for working day and ones (1) for non-working day. Each character represents a day of the week, starting with Monday. Only 1 and 0 are valid. “1111111” is an invalid string and should not be used. For example, the weekend string “0000011” defines Saturday and Sunday as non-working days.
Holidays is an array of dates or a reference to a range of cells containing them which is a list of holidays. These are non-working days. Enter a cell range in which the holidays are listed individually. 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.
- If StartDate or EndDate is not within the range for the current date base value, then the function returns a #VALUE! error.
- If Weekend is anything else except for 1 to 7, 11 to 17, and a valid string containing exact 7 integers either 0 or 1 (but not 1111111), then the function returns a #VALUE! error.
|=NETWORKDAYS.INTL(B1;B2;;B4:B8)||The function calculates the number of workdays with default for weekend days.||21|
|=NETWORKDAYS.INTL(B1;B2;11;B4:B8)||The function calculates the number of workdays with Sunday only weekends.||24|
|=NETWORKDAYS.INTL(B1;B2;“0000001”;B4:B8)||Alternatively, use the weekend string “0000001” to define Sunday as the non-working day of every week.||24|
|=NETWORKDAYS.INTL(B1;B20)||The function can be used without the two optional parameters – weekday and holidays – by leaving them out.||22|
Related LibreOffice functions:
Equivalent Excel functions: