Contact
12 programs
Explore the site

NETWORKDAYS.INTL Function (Gnumeric)

Date & Time Intermediate Gnumeric

Count weekdays inclusively between two dates using a custom weekend schedule and optional holidays.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Gnumeric. How formula examples are checked

Quick answer

NETWORKDAYS.INTL counts working dates including both the starting date and ending date when they qualify as workdays. Unlike plain NETWORKDAYS, its third argument lets you use a built-in weekend code or a seven-character weekend pattern. The fourth optional argument lists public holidays or business shutdown dates. The documented four-argument order is specific to the .INTL name: weekend comes before holidays. Tagged Gnumeric help and wrapper.

=NETWORKDAYS.INTL(DATE(2026,10,5),DATE(2026,10,11))

Expected result: 5. October 5–11, 2026 is Monday–Sunday, and five dates are Monday–Friday. This result was calculated independently in Python, not returned by Gnumeric.

Exact syntax and parameter defaults

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Argument Required? Type, position and meaning Default
start_date Yes Date value or numeric date serial (prefer DATE(year,month,day) to avoid ambiguous text formats). None
end_date Yes Second date/serial of the inclusive period. None
weekend No Whole-number built-in weekend code 1–7 or 11–17, or a seven-character text mask of zeros and ones ordered Monday → Sunday; 1 means non-working date. 1, Saturday/Sunday
holidays No Cell range or numeric-date array of excluded holiday dates. No extra holidays

A seven-character pattern such as "0000011" excludes Saturday and Sunday. "0000110" excludes Friday and Saturday, making Sunday a workday. Code 11 excludes Sunday only. The Gnumeric 1.12.62 source advertises these choices and the Excel-compatible argument order and delegates counting to its NETWORKDAYS implementation. Gnumeric 1.12.62 function implementation; Microsoft weekend-code reference (comparison reference only).

The formulas here use the English example form with commas. Locale/system settings may affect argument separators and date display; when pasting a formula fails, use Gnumeric’s formula editor and DATE(...) instead of a locale-specific typed date string. Official Gnumeric source.

Reproduce a one-week staffing count

Enter A2 as =DATE(2026,10,5) and B2 as =DATE(2026,10,11). Enter C2 as =DATE(2026,10,7) for a sample office closure. Fill D2 with the formulas below one at a time:

Formula Expected count What was independently checked
=NETWORKDAYS.INTL(A2,B2) 5 Monday through Friday, normal weekends.
=NETWORKDAYS.INTL(A2,B2,11) 6 Sunday is the sole excluded day; Saturday counts.
=NETWORKDAYS.INTL(A2,B2,"0000110") 5 Friday and Saturday excluded; Sunday counts.
=NETWORKDAYS.INTL(A2,B2,1,C2:C2) 4 October 7 falls on Wednesday and is excluded.
=NETWORKDAYS.INTL(A2,A2) 1 Monday, counted once because boundaries are inclusive.

Validation method: independently generated the seven calendar dates, applied weekend membership and removed the specified holiday; the outputs above are expected, not native observations.

Advanced use: nonstandard working weeks and holiday ranges

For a location closed Friday and Saturday, write "0000110" as weekend, because the mask positions are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. Place each closure in E2:E20 and use:

=NETWORKDAYS.INTL(A2,B2,"0000110",E2:E20)

If E2:E20 contains a date also excluded by the weekend mask, that date should not be subtracted twice. The Gnumeric helper filters weekend holidays and removes repeated holiday dates from its collected set. Tagged Gnumeric source, holiday filtering. Use actual date values, not text that merely resembles a date.

Important source-observed compatibility difference: The Gnumeric 1.12.62 implementation swaps start and end serial dates when given in reverse order before counting (gnumeric_networkdays), rather than visibly negating its result. This differs from Microsoft Excel’s usual negative-result description for reversed inputs; do not promise an Excel-identical signed result for reversed dates until tested in both apps. Tagged source. The calculation for reversed ranges was source-inspected, not executed.

Errors and troubleshooting

Symptom Explanation or check
#NUM! The tagged implementation rejects nonpositive date serial bounds, and some out-of-range serials may be invalid. Verify the workbook date system and DATE() input.
#VALUE! Invalid date conversion, weekend pattern or holiday contents can cause a value error. Check that the mask has seven 0/1 characters and holidays are numeric dates.
Unexpected 0 Every date may be marked as a weekend, or all qualifying dates may be holidays. Note: source handles an all-weekend pattern with 0; this differs from some Excel validation behavior.
Wrong count by one Start and end are included when they are working days. Check holidays and weekend-code ordering.
Wrong weekend The .INTL third argument is weekend; the older Gnumeric NETWORKDAYS has a different optional argument order.
#NAME? or unrecognized function Check Gnumeric version and plugin availability. .INTL was announced in 1.12.62, not earlier versions.

The 1.12.62 function registry marks the implementation COMPLETE but records NO_TESTSUITE. Neither that marker nor documentation review establishes behavior for every locale or runtime environment. Registry.

Official reference and verification

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Gnumeric.

  • No genuine Gnumeric screenshots are included; this guide does not use mock application images.