Ravindra BagaleCourses & study guides Track your progress

Excel NETWORKDAYS.INTL Function

By · Last updated:

Chala mitrano — today NETWORKDAYS.INTL. When the weekend is not Sat–Sun, tell Excel which days to skip.

Fictional sample data for learning. Gulf-style Fri+Sat weekends for a Dubai client managed from Pune.

Purpose

Count working days with a custom weekend pattern (and optional holidays).

Return value

A whole number of workdays.

Syntax

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

Arguments

ArgumentRequired?Description
start_dateRequiredStart date.
end_dateRequiredEnd date.
weekendOptionalWeekend code or 7-char string of 0/1 (Mon→Sun). Example 7 = Fri+Sat.
holidaysOptionalHoliday date range.

Version

Excel 2010+; Microsoft 365. LibreOffice has NETWORKDAYS.INTL with similar weekend codes.

How to use — Why → What → How

Why: Global teams do not share one weekend. INTL lets you model Fri+Sat or Sunday-only offs. Gulf-style Fri+Sat weekends for a Dubai client managed from Pune. In Indian back offices and foreign sister teams, NETWORKDAYS.INTL shows up on leave, SLA and invoice sheets every week.

What: Like NETWORKDAYS, but weekend picks the pattern. Code 7 means Friday and Saturday are weekend. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =NETWORKDAYS.INTL(A2,B2,7) for Fri+Sat weekend.
  2. Add holidays as the 4th argument.
  3. Document the weekend code on the sheet.

Ravindra Bagale's Tip

Friends, after you learn NETWORKDAYS.INTL, open a real leave or project sheet and find one cell this function would fix this week.

Ravindra Bagale's Tip

Friends, sleep on NETWORKDAYS.INTL and rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business question in plain words before you type =NETWORKDAYS.INTL.

Ravindra Bagale's Tip

Friends, after you finish NETWORKDAYS.INTL, open yesterday’s real workbook and find one place this function would have saved ten minutes. That habit turns lessons into salary skills.

Ravindra Bagale's Tip

Friends, treat NETWORKDAYS.INTL like a seatbelt on date sheets — use it before a manager asks why the deadline slipped.

Download practice file: practice-networkdays-intl.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Fri+Sat weekend Oct 2026

Dubai calendar from Pune.

StartEnd
2026-10-012026-10-31
Formula: =NETWORKDAYS.INTL(A2,B2,7)

Result: 21

What it means: Skips Fri+Sat; Sun–Thu count.

2) Default vs INTL

Compare.

StartEnd
2026-10-012026-10-31
Formula: =NETWORKDAYS(A2,B2)&" vs "&NETWORKDAYS.INTL(A2,B2,7)

Result: 22 vs 21

What it means: Different weekend → different count.

3) String mask Sun only

Sunday-only off.

StartEnd
2026-10-052026-10-11
Formula: =NETWORKDAYS.INTL(A2,B2,"0000001")

Result: 6

What it means: Mask Mon–Sun; 1 marks weekend (Sunday).

4) With holiday

Skip a Thursday holiday.

StartEndHol
2026-10-012026-10-152026-10-08
Formula: =NETWORKDAYS.INTL(A2,B2,7,C2)

Result: 10

What it means: Custom weekend plus holiday.

5) Short week

€ consulting.

StartEnd€
2026-10-042026-10-08900
Formula: =NETWORKDAYS.INTL(A2,B2,7)

Result: 5

What it means: Sun–Thu inside window.

6) Code reminder

Document codes.

CodeMeaning
1Sat+Sun
7Fri+Sat
Formula: (reference)

Result: use 7 for Fri+Sat

What it means: Write the code legend on the sheet.

About this data. Small demo rows for learning. Real sheets are longer; the same formula pattern scales when columns are clean.

Common errors and fixes

#NUM! — Bad weekend code. Fix: Use 1–17 or a 7-char 0/1 string.
#VALUE! — Bad dates. Fix: Fix types.
Wrong count — Forgot which weekend code. Fix: Print a legend.

Notes and tips

  • Revisit NETWORKDAYS.INTL errors after the quiz.
  • Build one example from memory.
  • Check date formats if results look wrong.
  • Teach one tip in Marathi or Hindi.
  • Keep currency consistent in one column (practice mixes ₹ $ £ €).
  • Note fallbacks when Excel versions differ.
  • Drill: recount October with code 7 and explain the difference aloud.
  • NETWORKDAYS.INTL vs NETWORKDAYS: custom weekend vs default Sat–Sun.
  • Fictional sample data only.
  • Print the NETWORKDAYS.INTL revision card.
  • Ask juniors to predict before Enter.
  • Track your top mistake monthly.
  • Gulf-style Fri+Sat weekends for a Dubai client managed from Pune.
  • Excel stores dates as serials.
  • Verify with a known calendar before long chains.
  • Print the revision card for NETWORKDAYS.INTL and stick it near your monitor for one week of real worksheets.
  • When helping a junior, ask them to predict the result before pressing Enter — prediction builds judgement.
  • Keep a personal notebook of the one mistake you make most often with this function; review it monthly.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • If a result looks wrong, check date formats and regional settings before changing the formula.
  • Date serial numbers are how Excel stores dates — formatting only changes the display.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • Classroom habit: after NETWORKDAYS.INTL, open yesterday’s real workbook and find one place this function saves time.
  • For interviews, explain why calendar days and working days differ on a project that crosses a weekend.

In real work

Drill: recount October with code 7 and explain the difference aloud. Gulf-style Fri+Sat weekends for a Dubai client managed from Pune. Classroom drill: write three brand-new NETWORKDAYS.INTL formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known calendar date before trusting a long chain of date formulas. Keep a personal notebook of the one mistake you make most often with this function; review it monthly. When Excel versions differ at home and in class, write the fallback formula under the modern one in a comment cell.

How it compares

NETWORKDAYS.INTL vs NETWORKDAYS: custom weekend vs default Sat–Sun.

Interview corner

Code 7?
Fri+Sat weekend.
Mask?
7 chars Mon→Sun.
vs NETWORKDAYS?
Custom vs Sat–Sun.

NETWORKDAYS, WORKDAY.INTL

Practice tasks (10)

  1. Task 1. Oct 2026 with weekend 7.
    INTL.
  2. Task 2. Compare to NETWORKDAYS.
    Both.
  3. Task 3. Sunday-only mask.
    0000001.
  4. Task 4. Add a holiday.
    4th.
  5. Task 5. Write code legend.
    Doc.
  6. Task 6. Explain Fri+Sat business case.
    Interview.
  7. Task 7. Short window count.
    5–8 Oct.
  8. Task 8. Invalid code → note error.
    #NUM!.
  9. Task 9. Teach classmate mask.
    Teach.
  10. Task 10. Bonus: WORKDAY.INTL pair.
    Related.

Quick quiz

Q1. Weekend code 7 usually means:
Q2. String mask length:
Q3. When to use INTL:
Q4. Holidays in INTL:
Q5. Default NETWORKDAYS weekend:

Answers: Q1=Fri+Sat, Q2=7 (Mon→Sun), Q3=Non Sat–Sun weekends, Q4=4th argument, Q5=Sat+Sun (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: NETWORKDAYS.INTL
NETWORKDAYS.INTL revision card