NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend

⏱ 1 min readUpdated 28 September 2026

DateLevel: ExpertAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

NETWORKDAYS.INTL counts working days when your weekend is not Saturday–Sunday — a Sunday-only week, or a Friday–Saturday weekend in the Gulf.

Syntax

=NETWORKDAYS.INTL(start, end, [weekend], [holidays])
Argument What it means
weekend Code (11 = Sunday only) or a 7-character mask “0000011” starting Monday, 1 = off.

Examples

Example 1

=NETWORKDAYS.INTL(A2, B2, 11, Holidays)

Six-day week with Sundays off, minus holidays.

Example 2

=NETWORKDAYS.INTL(A2, B2, "0000101")

Off on Friday and Sunday.

NETWORKDAYS · WORKDAY.INTL

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZMOD Function in Excel: Remainder After DivisionExcel Functions A–ZGETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot TableExcel Functions A–ZPMT Function in Excel: Loan EMI in One Formula
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong