NETWORKDAYS.INTL Function (LibreOffice Calc)

• Counts working days between two dates
• Lets you define custom weekends
• Optionally excludes holidays
• Includes both start and end dates
• Works with serial dates or text dates

It is designed to be flexible, international, and ideal for complex business‑day calculations.

NETWORKDAYS.INTL(start_date; end_date; [weekend]; [holidays])

Arguments

• start_date:
  The beginning date.

• end_date:
  The ending date.

• weekend (optional):
  Defines which days are weekends.
  Can be a code or a 7‑character string.

• holidays (optional):
  A range of dates to exclude.

A 7‑character string of 0s and 1s:

• Position 1 = Monday
• Position 7 = Sunday
• 1 = weekend
• 0 = working day

Examples:

• 0000011 → Saturday & Sunday weekend
• 1000000 → Monday weekend only
• 0000100 → Friday weekend only
• 0000111 → Fri–Sat–Sun weekend

Count working days with default weekend (Sat–Sun)

=NETWORKDAYS.INTL("2024-01-01"; "2024-01-31")

Count working days with Friday–Saturday weekend

=NETWORKDAYS.INTL("2024-01-01"; "2024-01-31"; 7)

Count working days with Sunday‑only weekend

=NETWORKDAYS.INTL("2024-01-01"; "2024-01-31"; 11)

Count working days with custom weekend string (Fri–Sun)

=NETWORKDAYS.INTL("2024-01-01"; "2024-01-31"; "0000111")

Count working days excluding holidays

=NETWORKDAYS.INTL(A1; B1; "0000011"; C1:C10)

Count working days in a month (custom weekend)

=NETWORKDAYS.INTL(DATE(YEAR(A1);MONTH(A1);1); EOMONTH(A1;0); "0000011")

Count working days in a quarter

=NETWORKDAYS.INTL(A1; EDATE(A1;3)-1; "0000011")

Count working days from text dates

=NETWORKDAYS.INTL(DATEVALUE(A1); DATEVALUE(B1); "0000011")

Count working days from imported CSV timestamps

=NETWORKDAYS.INTL(DATEVALUE(LEFT(A1;10)); DATEVALUE(LEFT(B1;10)); "0000011")

Count working days from Excel serial dates stored as text

=NETWORKDAYS.INTL(DATE(1899;12;30)+VALUE(A1); DATE(1899;12;30)+VALUE(B1); "0000011")

Count working days remaining in the year

=NETWORKDAYS.INTL(TODAY(); DATE(YEAR(TODAY());12;31); "0000011")

Count working days elapsed in the year

=NETWORKDAYS.INTL(DATE(YEAR(TODAY());1;1); TODAY(); "0000011")

Holiday list example

Use:

=NETWORKDAYS.INTL(A1; B1; "0000011"; C1:C3)

Holidays must be real dates

Use DATEVALUE if imported as text.

Holidays override weekends only if they fall on working days

NETWORKDAYS.INTL returns an integer

Accepts:

• Real dates
• Serial numbers
• DATEVALUE outputs
• ISO date strings

Invalid text → Err:502

Time components are ignored

Start and end dates are inclusive

Negative results allowed if end_date < start_date

Weekend string must be exactly 7 characters

NETWORKDAYS.INTL of an error → error propagates

• Use NETWORKDAYS.INTL for any non‑standard weekend schedule
• Use NETWORKDAYS for standard Sat–Sun weekends
• Normalize text dates with DATEVALUE
• Store holidays in a dedicated range or named range
• Use custom weekend strings for maximum control
• Use NETWORKDAYS.INTL with EDATE/EOMONTH for period analysis

• Use NETWORKDAYS for standard weekends
• Use WORKDAY.INTL for business‑day offsets with custom weekends
• Use WORKDAY for standard weekend offsets
• Use DATE for constructing comparison dates
• Use DAYS for calendar‑day differences

By mastering NETWORKDAYS.INTL and its companion functions, you can build powerful, flexible, and fully business‑aware date‑analysis workflows in LibreOffice Calc.