Wauvel

Excel like a finance pro.

← The library

Date function

NETWORKDAYS.INTL

Counts working days with a custom definition of the weekend.

OccasionalDifficulty 1300 · ProficientUsage rank #201 of 520
Practice · 3 questions →

When to use it

NETWORKDAYS with a configurable weekend: a number code or a seven-character string of 1s (weekend) and 0s starting Monday.

The shape of it

Syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Worked examples

  • Six-day week

    =NETWORKDAYS.INTL(DATE(2025,3,3),DATE(2025,3,14),11) → 11

    Weekend code 11 is Sunday only.

  • String weekend

    =NETWORKDAYS.INTL(DATE(2025,3,3),DATE(2025,3,14),"0000011") → 10

    The string form: Saturday and Sunday off.

  • Friday-Saturday weekend

    =NETWORKDAYS.INTL(A2,B2,7,Holidays) → 9

    Code 7 is Friday and Saturday, common in the Middle East.

Worth knowing

  • Codes 1 to 7 are two-day weekends starting Saturday-Sunday; 11 to 17 are single days starting Sunday.
  • The string lets you model a four-day week: "0000111".
  • Holidays work the same as NETWORKDAYS.

Where it goes wrong

  • A string of seven 1s returns #VALUE!.
  • Codes 8, 9, 10 are invalid.

Related

TODAYDATEMONTHYEARNOWDAY

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.