DAYOFWEEK in LibreOffice Calc: Availability and Alternatives
DAYOFWEEK is not a documented native Calc function in the checked release. Use WEEKDAY and specify the numbering convention.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
DAYOFWEEK is not a supported English built-in or bundled-add-in function name in the checked LibreOffice 26.8.1.1 registry. Use WEEKDAY and specify the numbering convention. 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.
Return a weekday number with WEEKDAY
For Monday=1 through Sunday=7, use:
=WEEKDAY(DATE(2026;4;2);2)
Expected result: 4, because April 2, 2026 is Thursday. The second argument selects the numbering convention. It is important when formulas compare the result against a cutoff.
| Formula | Expected result for 2026-04-02 | Convention |
|---|---|---|
=WEEKDAY(DATE(2026;4;2);1) |
5 | Sunday=1 through Saturday=7 |
=WEEKDAY(DATE(2026;4;2);2) |
4 | Monday=1 through Sunday=7 |
=WEEKDAY(DATE(2026;4;2);3) |
3 | Monday=0 through Sunday=6 |
Flag a weekend without relying on the default
With a genuine date in A2, =WEEKDAY(A2;2)>5 flags Saturday and Sunday. The explicit type 2 makes the comparison readable: weekdays are 1–5 and the weekend is 6–7. That rule would be wrong if the formula instead used Sunday=1 numbering.
If a name such as Thursday is wanted, use a date format or TEXT with an appropriate locale-specific format code. A day name and a weekday number are different outputs; do not compare a localized name to a numeric weekend threshold.
Migration checks
Use DATE(year;month;day) or a genuine date cell rather than an ambiguous quoted date. Check how the source program numbered weekdays, then choose the matching WEEKDAY type. An unsupported DAYOFWEEK name can also belong to a database language rather than the spreadsheet formula language; that does not make it a Calc alias.
The former formulas were removed from the active instructions because renaming a database or other-product function by analogy is not availability evidence.