Function note

NETWORKDAYS.INTL checks weekend before the dates, WORKDAY.INTL after them

FUNC.NETWORKDAYS.INTL · FUNC.WORKDAY.INTL

FN-NETWORKDAYS.INTL-001: NETWORKDAYS.INTL checks weekend before the dates, WORKDAY.INTL after them

Quirk · measured · recorded 2026-11-04

The two functions read their arguments in different orders. NETWORKDAYS.INTL decodes weekend first: with #REF! in the cell for start_date and weekend 0, the answer is #NUM!, from the invalid weekend. WORKDAY.INTL reads start_date first and gives #REF! for the same arguments. An error held in the weekend cell is also treated differently: with start 2 and second argument 5, NETWORKDAYS.INTL gives #VALUE! and WORKDAY.INTL gives #NUM!. Neither returns the error itself. A logical weekend is read as a number: NETWORKDAYS.INTL(2,5,TRUE) is 4, as with weekend 1, and FALSE is #NUM!, as with weekend 0. WORKDAY.INTL does the same.

Call and input routeInputsExcelCorrect valueRecorded in
NETWORKDAYS.INTL(A1, 5, 0)
cell-value2		start_date: #REF!
end_date: 5
0x4014000000000000
weekend: 0
0x0000000000000000		#NUM!—Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file
WORKDAY.INTL(A1, 5, 0)
cell-value2		start_date: #REF!
days: 5
0x4014000000000000
weekend: 0
0x0000000000000000		#REF!—Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file
NETWORKDAYS.INTL(2, 5, A3)
cell-value2		start_date: 2
0x4000000000000000
end_date: 5
0x4014000000000000
weekend: #REF!		#VALUE!—Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file
WORKDAY.INTL(2, 5, A3)
cell-value2		start_date: 2
0x4000000000000000
days: 5
0x4014000000000000
weekend: #REF!		#NUM!—Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file
=NETWORKDAYS.INTL(2,5,TRUE)
formula-literal		As typed4
0x4010000000000000		—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=NETWORKDAYS.INTL(2,5,FALSE)
formula-literal		As typed#NUM!—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=WORKDAY.INTL(2,2,TRUE)
formula-literal		As typed4
0x4010000000000000		—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=WORKDAY.INTL(2,2,FALSE)
formula-literal		As typed#NUM!—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA

Basis: 19 NETWORKDAYS.INTL and 20 WORKDAY.INTL readings with errors held in cells, and the logical weekend readings of the argument sheets.

Evidence and capture sources

Machine-readable note records