NETWORKDAYS.INTL
Returns 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 ] ])
StartDate is the 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 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.
Number
|
Weekend
|
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
|
11
|
Sunday only
|
12
|
Monday only
|
13
|
Tuesday only
|
14
|
Wednesday only
|
15
|
Thursday only
|
16
|
Friday only
|
17
|
Saturday only
|
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 optional list of dates that must be counted as non-working days. The list can be given in a cell range.

ΠΡΠΈ Π²Π²ΠΎΠ΄Π΅ Π΄Π°Ρ ΠΊΠ°ΠΊ ΡΠ°ΡΡΠΈ ΡΠΎΡΠΌΡΠ», ΠΊΠΎΡΡΠ΅ ΡΠ΅ΡΡΡ ΠΈΠ»ΠΈ ΡΠΈΡΠ΅, ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΠ΅ΠΌΡΠ΅ Π² ΠΊΠ°ΡΠ΅ΡΡΠ²Π΅ ΡΠ°Π·Π΄Π΅Π»ΠΈΡΠ΅Π»Π΅ΠΉ Π΄Π°Ρ, ΠΈΠ½ΡΠ΅ΡΠΏΡΠ΅ΡΠΈΡΡΡΡΡΡ ΠΊΠ°ΠΊ Π°ΡΠΈΡΠΌΠ΅ΡΠΈΡΠ΅ΡΠΊΠΈΠ΅ ΠΎΠΏΠ΅ΡΠ°ΡΠΎΡΡ. ΠΠΎΡΡΠΎΠΌΡ Π΄Π°ΡΡ, Π²Π²Π΅Π΄Π΅Π½Π½ΡΠ΅ Π² ΡΡΠΎΠΌ ΡΠΎΡΠΌΠ°ΡΠ΅, Π½Π΅ ΡΠ°ΡΠΏΠΎΠ·Π½Π°ΡΡΡΡ ΠΊΠ°ΠΊ Π΄Π°ΡΡ ΠΈ ΠΏΡΠΈΠ²ΠΎΠ΄ΡΡ ΠΊ ΠΎΡΠΈΠ±ΠΎΡΠ½ΡΠΌ Π²ΡΡΠΈΡΠ»Π΅Π½ΠΈΡΠΌ. Π§ΡΠΎΠ±Ρ Π΄Π°ΡΡ Π½Π΅ ΠΈΠ½ΡΠ΅ΡΠΏΡΠ΅ΡΠΈΡΠΎΠ²Π°Π»ΠΈΡΡ ΠΊΠ°ΠΊ ΡΠ°ΡΡΠΈ ΡΠΎΡΠΌΡΠ», ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΠΉΡΠ΅ ΡΡΠ½ΠΊΡΠΈΡ DATE, Π½Π°ΠΏΡΠΈΠΌΠ΅Ρ DATE (1954;7;20) ΠΈΠ»ΠΈ ΠΏΠΎΠΌΠ΅ΡΡΠΈΡΠ΅ Π΄Π°ΡΡ Π² ΠΊΠ°Π²ΡΡΠΊΠΈ ΠΈ ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΠΉΡΠ΅ Π½ΠΎΡΠ°ΡΠΈΡ ISO 8601, Π½Π°ΠΏΡΠΈΠΌΠ΅Ρ "1954-07-20". ΠΠ·Π±Π΅Π³Π°ΠΉΡΠ΅ ΠΈΡΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°Π½ΠΈΡ ΡΠΎΡΠΌΠ°ΡΠΎΠ² Π΄Π°ΡΡ, Π·Π°Π²ΠΈΡΡΡΠΈΡ
ΠΎΡ Π»ΠΎΠΊΠ°Π»ΡΠ½ΡΡ
Π½Π°ΡΡΡΠΎΠ΅ΠΊ, ΡΠ°ΠΊΠΈΡ
ΠΊΠ°ΠΊ "07/20/54", ΡΠ°ΡΡΡΡ ΠΌΠΎΠΆΠ΅Ρ ΠΏΡΠΈΠ²Π΅ΡΡΠΈ ΠΊ ΠΎΡΠΈΠ±ΠΊΠ°ΠΌ, Π΅ΡΠ»ΠΈ Π΄ΠΎΠΊΡΠΌΠ΅Π½Ρ Π·Π°Π³ΡΡΠΆΠ΅Π½ Π² ΡΠΎΠΎΡΠ²Π΅ΡΡΡΠ²ΠΈΠΈ Ρ ΠΈΠ½ΡΠΌΠΈ Π»ΠΎΠΊΠ°Π»ΡΠ½ΡΠΌΠΈ Π½Π°ΡΡΡΠΎΠΉΠΊΠ°ΠΌΠΈ.
Unambiguous conversion is possible for ISO 8601 dates and times in their extended formats with separators. If a #VALUE! error occurs, then unselect Generate #VALUE! error in LibreOffice - PreferencesTools - Options - LibreOffice Calc - Formula, button Details... in section "Detailed Calculation Settings", Conversion from text to number list box.
This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.
How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017.
=NETWORKDAYS.INTL(C3;D3;;F3:J3) returns 21 workdays with default for weekend days.
=NETWORKDAYS.INTL(C3;D3;11;F3:J3) returns 24 workdays with Sunday only weekends.
Alternatively, use the weekend string β0000001β to define Sunday as the non-working day of every week.
=NETWORKDAYS.INTL(C3;D3;β0000001β;F3:J3) returns 24 workdays with Sunday only weekend.
The function can be used without the two optional parameters β weekday and holidays β by leaving them out:
=NETWORKDAYS.INTL(C3;D3) gives 22 working days.
This function is available since LibreOffice 4.3.
This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is
COM.MICROSOFT.NETWORKDAYS.INTL