BUSDAY in LibreOffice Calc: Availability and Alternatives
BUSDAY is not a documented native Calc function in the checked release. Use WORKDAY to find the next working date.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
BUSDAY is not a supported English built-in or bundled-add-in function name in the checked LibreOffice 26.8.1.1 registry. Use WORKDAY to find the next working date. 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 Monday-to-Friday workday
Use WORKDAY with an explicit offset of one:
=WORKDAY(DATE(2026;3;1);1)
Expected date: 2026-03-02. March 1, 2026 is a Sunday, so the next default workday is Monday. Format the result cell as a date; a plain number display may show the underlying date serial instead.
For a worksheet, put a genuine date in A2 and enter =WORKDAY(A2;1) in B2. The offset matters: WORKDAY(A2;0) is a different request and must not be assumed to mean the next business day.
Include your own holiday list
Put holidays as genuine date values in H2:H10 and use:
=WORKDAY(A2;1;$H$2:$H$10)
The dollar signs keep the holiday range fixed when copying down. The function does not automatically know a country’s public holidays, your company’s closures or a bank’s settlement calendar. Maintain the list that applies to the task.
When to choose another function
WORKDAY returns an offset date. NETWORKDAYS counts working days across a date interval; it does not return the next date. WORKDAY.INTL is the relevant alternative when weekends differ from Saturday/Sunday.
Avoid ambiguous literal dates such as "03/01/2026" in a portable formula. DATE(2026;3;1) makes year, month and day explicit. Check the original signed offset and calendar assumptions when migrating an imported formula.
The previous BUSDAY formulas have been replaced. Their desired scheduling operation is still possible, but the supported Calc function has different arguments.