Date & Time
NETWORKDAYS.INTL Function in Excel
Returns the number of whole workdays between two dates with custom weekend parameters.
Syntax
- =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments
- start_date (required): Start date
- end_date (required): End date
- weekend (optional): Weekend days (1-7 or string)
- holidays (optional): Holiday dates to exclude
Examples
- =NETWORKDAYS.INTL("1/1/2024", "1/31/2024", 1) - Workdays with Sat-Sun weekend - Result: 23
Excel NETWORKDAYS.INTL function documentation
- NETWORKDAYS.INTL counts workdays between dates with custom weekend rules.
- Syntax: =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]).
- Mirror of [WORKDAY.INTL](/functions/workday-intl/) for duration not end date.
- Related: [NETWORKDAYS](/functions/networkdays/), [DATEDIF](/functions/datedif/), [WORKDAY](/functions/workday/).
NETWORKDAYS.INTL syntax
- start_date and end_date inclusive/exclusive rules match NETWORKDAYS family.
- weekend code same as WORKDAY.INTL.
- holidays range excluded from count.
- Order of dates — swap if end before start returns negative in some contexts — check Excel behavior.
Step-by-step: SLA business days ticket open
- Step 1 — Open date A2, close B2.
- Step 2 — =NETWORKDAYS.INTL(A2, B2, 1, holiday_range).
- Step 3 — SLA breach: =IF(NETWORKDAYS.INTL(A2,B2,1,holidays)>5,"Breached","OK").
- Step 4 — Exclude open day or include per policy — document convention.
- Step 5 — Compare plain [NETWORKDAYS](/functions/networkdays/) for US calendar.
NETWORKDAYS.INTL vs DATEDIF vs NETWORKDAYS
- NETWORKDAYS.INTL — business days custom weekend.
- DATEDIF — calendar days/months/years.
- NETWORKDAYS — Sat-Sun US default.
- Global teams — standardize weekend code in Settings sheet.
Worked examples to copy
- Count: =NETWORKDAYS.INTL(A2, B2, 1).
- Fri-Sat off: =NETWORKDAYS.INTL(A2, B2, 7).
- With holidays: =NETWORKDAYS.INTL(A2, B2, 1, Hols).
- Same month SLA: compare to 22 business day benchmark.
People also ask
- NETWORKDAYS.INTL inclusive? — Both endpoints counted if workdays — see docs.
- NETWORKDAYS.INTL partial days? — Date serials include time — use INT on dates.
- NETWORKDAYS.INTL wrong count? — Wrong weekend code or holiday list.
- NETWORKDAYS.INTL 365? — Same function name in Microsoft 365.
Common errors
- Weekend parameter varies by region
Use cases
- International scheduling
- Custom work weeks
- Project planning
Frequently asked questions
- What is NETWORKDAYS.INTL used for? NETWORKDAYS.INTL counts working days between dates with customizable weekends. Unlike NETWORKDAYS (Saturday-Sunday only), it handles different weekend patterns used globally - Friday-Saturday in Middle East, Sunday only in some countries, etc.
- How do I specify custom weekends? Use weekend parameter: 1=Sat-Sun, 2=Sun-Mon, 7=Fri-Sat, 11=Sun only, etc. Or use a 7-character string of 1s and 0s (1=weekend): '0000011' = Sat-Sun weekend, '1000001' = Fri-Sat weekend. String gives most flexibility.
- How do I count workdays with Friday-Saturday weekend? Use =NETWORKDAYS.INTL(start, end, 7) or =NETWORKDAYS.INTL(start, end, "0000011"). Weekend=7 means Friday-Saturday are weekends. Add holidays array as 4th parameter to exclude specific dates.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use NETWORKDAYS.INTL
- International scheduling — common Date & Time scenario for NETWORKDAYS.INTL.
- Custom work weeks — common Date & Time scenario for NETWORKDAYS.INTL.
- Project planning — common Date & Time scenario for NETWORKDAYS.INTL.
NETWORKDAYS.INTL in the Date & Time category
- Browse all Date & Time functions at /categories/date-time/ for related formulas.
- NETWORKDAYS.INTL syntax: =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
- start_date (required): Start date
- end_date (required): End date
- weekend (optional): Weekend days (1-7 or string)
- holidays (optional): Holiday dates to exclude
- Confirm NETWORKDAYS.INTL arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm NETWORKDAYS.INTL arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- NETWORKDAYS (/functions/networkdays/): Returns the number of whole working days between two dates, excluding weekends and holidays.
- WORKDAY.INTL (/functions/workday-intl/): Returns the date after a specified number of workdays with custom weekend parameters.
- DAYS (/functions/days/): Returns the number of days between two dates.
Errors to watch for
- Weekend parameter varies by region — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter NETWORKDAYS.INTL on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
NETWORKDAYS.INTL worked examples to copy
- =NETWORKDAYS.INTL("1/1/2024", "1/31/2024", 1) — Workdays with Sat-Sun weekend. Expected result: 23.
NETWORKDAYS.INTL reference summary for crawlers and offline review
- NETWORKDAYS.INTL belongs to the Date & Time category in Excel. Returns the number of whole workdays between two dates with custom weekend parameters.
- Full syntax: =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]). Open /functions/networkdays-intl/ for parameters, FAQs, and related pages.
- Common mistakes: Weekend parameter varies by region
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.