BUSDAY Function (LibreOffice Calc)

• Returns the next business day after a given date
• Excludes weekends automatically
• Can exclude holidays if provided
• Useful for due dates, settlement dates, and workflow automation

BUSDAY(start_date; holidays)

Arguments

• start_date:
  The date from which to calculate the next business day.

• holidays (optional):
  A range of dates to exclude (bank holidays, company closures, etc.).

Next business day after a date

=BUSDAY("2026-03-01")
→ 2026-03-02  (if March 1 is a Sunday)

Using a cell reference

=BUSDAY(A1)

With a holiday list

=BUSDAY(A1; B1:B10)

If the start date is already a business day

=BUSDAY("2026-03-03")
→ 2026-03-04

Skip weekends and custom holidays

=BUSDAY(A1; {"2026-03-17"; "2026-03-20"})

Use with TODAY()

=BUSDAY(TODAY())

Use with EDATE for month‑end workflows

=BUSDAY(EDATE(A1; 1); Holidays)

Generate a rolling business‑day schedule

=BUSDAY(BUSDAY(A1))

Combine with TEXT for formatted output

=TEXT(BUSDAY(A1); "YYYY-MM-DD")

BUSDAY returns a date serial number

Format the cell as a date if needed.

Behavior details

• If start_date is a weekend → returns the next Monday
• If start_date is a holiday → returns the next non‑holiday weekday
• If holidays is omitted → only weekends are excluded
• Does not allow custom weekend patterns (use BUSDAY.INTL for that)

Invalid input → Err:502

BUSDAY of an error → error propagates

• Use BUSDAY.INTL for custom weekend rules
• Use WORKDAY when you need to add N business days
• Maintain a central holiday list for consistency
• Wrap with TEXT for formatted output
• Validate date inputs to avoid errors

• BUSDAY.INTL — next business day with custom weekend rules
• WORKDAY / WORKDAY.INTL — add N business days
• NETWORKDAYS / NETWORKDAYS.INTL — count business days
• DATEADD — general date arithmetic

By mastering BUSDAY, you can build robust business‑day logic into any financial or operational model.