BUSDAY.INTL Function (LibreOffice Calc)
The BUSDAY.INTL function returns the next business day after a given date, using customizable weekend patterns and optional holiday exclusions. It is used in financial modeling, scheduling, and international workflows where weekend definitions vary.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✖ |
| Libreoffice | ✔ |
| Numbers | ✖ |
| Onlyoffice | ✔ |
| Openoffice | ✖ |
| Wps | ✔ |
| Zoho | ✖ |
What the BUSDAY.INTL Function Does â–¾
- Returns the next business day after a given date
- Allows custom weekend definitions
- Supports optional holiday lists
- Used in global finance, logistics, and scheduling
Syntax â–¾
BUSDAY.INTL(start_date; weekend; holidays)
Arguments
-
start_date:
The date from which to calculate the next business day. -
weekend (optional):
A weekend code or 7‑character string defining weekend days. -
holidays (optional):
A range of dates to exclude.
Weekend Codes â–¾
Numeric weekend codes
| Code | Weekend Days |
|---|---|
| 1 | Saturday–Sunday (default) |
| 2 | Sunday–Monday |
| 3 | Monday–Tuesday |
| 4 | Tuesday–Wednesday |
| 5 | Wednesday–Thursday |
| 6 | Thursday–Friday |
| 7 | Friday–Saturday |
| 11 | Sunday only |
| 12 | Monday only |
| 13 | Tuesday only |
| 14 | Wednesday only |
| 15 | Thursday only |
| 16 | Friday only |
| 17 | Saturday only |
7‑character weekend string
Example:
"0000011"
Each character represents a day (Mon→Sun).
1 = weekend, 0 = workday.
Basic Examples â–¾
Default weekend (Saturday–Sunday)
=BUSDAY.INTL("2026-03-01")
→ 2026-03-02
Custom weekend (Friday–Saturday)
=BUSDAY.INTL(A1; 7)
Weekend string (Sunday only)
=BUSDAY.INTL(A1; "0000001")
With holidays
=BUSDAY.INTL(A1; 1; B1:B10)
Advanced Examples â–¾
Middle East weekend (Fri–Sat)
=BUSDAY.INTL(A1; 7)
Japanese weekend (Sat–Sun) with Golden Week holidays
=BUSDAY.INTL(A1; 1; Holidays_JP)
Use with TODAY()
=BUSDAY.INTL(TODAY(); 1)
Generate a chain of business days
=BUSDAY.INTL(BUSDAY.INTL(A1; 1); 1)
Combine with TEXT for formatting
=TEXT(BUSDAY.INTL(A1; 1); "YYYY-MM-DD")
Edge Cases and Behavior Details â–¾
BUSDAY.INTL returns a date serial number
Format the cell as a date if needed.
Behavior details
- If start_date is a weekend → returns the next workday
- If start_date is a holiday → returns the next non‑holiday workday
- Weekend patterns override default Saturday–Sunday
- Holiday list is optional
Invalid input → Err:502
BUSDAY.INTL of an error → error propagates
Common Errors and Fixes â–¾
Err:502 — Invalid argument
Cause:
- Invalid weekend code
- Weekend string not 7 characters
- Non‑date input
Fix:
- Validate weekend code
- Ensure weekend string is exactly 7 characters
- Use DATEVALUE for text dates
Unexpected weekend behavior
Cause:
- Weekend string misaligned (Mon→Sun)
Fix:
- Verify character order
Best Practices â–¾
- Use BUSDAY.INTL for international workflows
- Use WORKDAY.INTL when you need to add N business days
- Maintain a central holiday list
- Use weekend strings for maximum control
- Validate date inputs
BUSDAY.INTL is essential for global operations — it adapts to any weekend pattern, making it far more flexible than BUSDAY.
Related Patterns and Alternatives â–¾
- BUSDAY — next business day (fixed weekend)
- WORKDAY / WORKDAY.INTL — add N business days
- NETWORKDAYS / NETWORKDAYS.INTL — count business days
- DATEADD — general date arithmetic
By mastering BUSDAY.INTL, you can build robust, international business‑day logic into any financial or operational model.