BUSDAY.INTL in LibreOffice Calc: Availability and Alternatives
BUSDAY.INTL is not a documented native Calc function in the checked release. Use WORKDAY.INTL with an explicit day offset and weekend.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
BUSDAY.INTL is not a supported English built-in or bundled-add-in function name in the checked LibreOffice 26.8.1.1 registry. Use WORKDAY.INTL with an explicit day offset and weekend. The page is retained at its existing URL to explain the compatibility problem and give a usable next step.
Availability and version history
- First introduced: Not established. The former legacy/version claim was unsupported and has been withdrawn.
- Current status: Unsupported under this name in the verified release inventory. This is not a claim that the function was once supported and then retired.
- Last supported version / retirement: Unknown; no documented historical endpoint was found.
- Platform and edition scope: English function names in desktop Calc, including its bundled analysis/date/pricing add-ins. A third-party extension may register additional names but is not evidence for native support.
- Native testing: A representative imported-XLSX call returned #NAME? in LibreOfficeDev 26.8.0.0.alpha0 (build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5). The replacement examples below have independent expected results; selected principal examples were also cross-checked in that development build. This does not establish behavior in every stable version.
- Evidence checked: 2026-10-14.
The complete source check covered the built-in function registry, English names, analysis add-ins, date add-ins and pricing add-ins. Absence from one abbreviated web index alone was not used as proof.
Find the next workday with a custom weekend
WORKDAY.INTL accepts the start date, day offset, weekend definition and an optional holiday list. For a calendar where only Sunday is non-working:
=WORKDAY.INTL(DATE(2026;3;6);1;"0000001")
Expected date: 2026-03-07, a Saturday. The seven-character weekend string runs Monday through Sunday: 1 means non-working and 0 means working. Saturday is allowed in this particular calendar.
The 1 after the date is the number of working days to move. It is not the weekend code. This is why an unsupported BUSDAY.INTL formula must be translated by meaning rather than renamed blindly.
Reusable worksheet formula
Put the start date in A2, the weekend string in F2, and holidays in H2:H10. Use:
=WORKDAY.INTL(A2;1;$F$2;$H$2:$H$10)
Store the weekend pattern as text so leading zeroes survive. Keep the calendar cells fixed when filling down. Format the output as a date, and test a Friday, Saturday, Sunday and holiday before trusting a schedule.
Calendar checks
- The weekend definition determines recurring non-working weekdays; the holiday range supplies additional dates.
- An all-non-working pattern cannot provide a next working date.
- The function does not fetch a national holiday calendar.
- NETWORKDAYS.INTL counts dates in an interval; use WORKDAY.INTL to return an offset date.
A versioned source check establishes that WORKDAY.INTL is available; it does not establish that every imported BUSDAY.INTL convention maps to the same calendar. Preserve the original business rule when translating a workbook.