WORKDAY.INTL
Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.
This function is available since LibreOffice 4.3
WORKDAY.INTL(StartDate; Days; Weekend; Holidays)
StartDate: is the date from when the calculation is carried out.
Days is the number of workdays. Positive value for a result after the start date, negative value for a result before the start date.
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.
What date comes 20 workdays after December 13, 2016? Enter the start date in C3 and the number of workdays in D3.
The weekend parameter (number) may be left blank or defined as 1 for default weekend (non-working days) β Saturday and Sunday.
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.
=WORKDAY.INTL(C3;D3;;F3:J3) returns January 11, 2017 in the result cell, say D6 (use date format for the cell).
To define Friday and Saturday as weekend days, use the weekend parameter 7.
=WORKDAY.INTL(C3;D3;7;F3:J3) returns January 15, 2017 with weekend parameter 7.
To define Sunday only the weekend day, use the weekend parameter 11.
=WORKDAY.INTL(C3;D3;11;F3:J3) returns January 9, 2017.
Alternatively, use the weekend string "0000001" for Sunday only weekend.
=WORKDAY.INTL(C3;D3;"0000001";F3:J3) returns January 9, 2017.
The function can be used without the two optional parameters β Weekday and Holidays β by leaving them out:
=WORKDAY.INTL(C3;D3) gives the result: January 10, 2017.