Excel NETWORKDAYS Function
Chala mitrano — today NETWORKDAYS. Count Mon–Fri between two dates, and knock out holidays if you list them.
चला मित्रांनो — आज NETWORKDAYS. दोन तारखांमधील Mon–Fri मोजा; holidays असतील तर वगळा.
चलो दोस्तों — आज NETWORKDAYS. दो तारीखों के बीच Mon–Fri गिनो; holidays हों तो हटाओ.
Purpose
Count working days between two dates (skips weekends; optional holidays).
Return value
A whole number of workdays.
Syntax
Arguments
| Argument | Required? | Description |
|---|---|---|
start_date | Required | First date of the span (included if a workday). |
end_date | Required | Last date of the span (included if a workday). |
holidays | Optional | Range of holiday dates to skip. |
Version
All modern Excel; LibreOffice NETWORKDAYS too.
How to use — Why → What → How
Why: Clients ask ‘how many working days do we have?’ Calendar days lie when weekends sit in the middle. Project plans in Pune IT and Dublin agencies count delivery days. In Indian back offices and foreign sister teams, NETWORKDAYS shows up on leave, SLA and invoice sheets every week.
What: NETWORKDAYS counts weekdays from start through end, minus holidays listed. Read every argument in the table once before you type; each one changes the answer on purpose.
How — numbered steps:
- Type =NETWORKDAYS(A2,B2).
- Add a holiday range as the third argument when needed.
- Confirm both ends are real dates.
Ravindra Bagale's Tip
Friends, after you learn NETWORKDAYS, open a real leave or project sheet and find one cell this function would fix this week.
Ravindra Bagale's Tip – मराठी
मित्रांनो, NETWORKDAYS शिकून झाल्यावर खरी leave/project sheet उघडा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, NETWORKDAYS सीखने के बाद असली leave/project sheet खोलो.
Ravindra Bagale's Tip
Friends, sleep on NETWORKDAYS and rebuild example 1 tomorrow without looking.
Ravindra Bagale's Tip – मराठी
मित्रांनो, NETWORKDAYS वर एक रात्र झोपा आणि उद्या उदाहरण 1 न पाहता पुन्हा लिहा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, NETWORKDAYS पर एक रात सोकर कल उदाहरण 1 बिना देखे फिर लिखो.
Ravindra Bagale's Tip
Friends, say the business question in plain words before you type =NETWORKDAYS.
Ravindra Bagale's Tip – मराठी
मित्रांनो, =NETWORKDAYS टाइप करण्यापूर्वी प्रश्न साध्या शब्दांत सांगा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, =NETWORKDAYS टाइप करने से पहले सवाल सादे शब्दों में बोलो.
Ravindra Bagale's Tip
Friends, after you finish NETWORKDAYS, 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 – मराठी
मित्रांनो, NETWORKDAYS शिकून झाल्यावर कालची खरी वर्कबुक उघडा आणि शोधा जिथे हे फंक्शन दहा मिनिटे वाचवू शकले असते.
Ravindra Bagale's Tip – हिंदी
दोस्तों, NETWORKDAYS सीखने के बाद कल की असली वर्कबुक खोलो और ढूँढो जहाँ यह फ़ंक्शन दस मिनट बचा सकता था.
Ravindra Bagale's Tip
Friends, treat NETWORKDAYS like a seatbelt on date sheets — use it before a manager asks why the deadline slipped.
Ravindra Bagale's Tip – मराठी
मित्रांनो, NETWORKDAYS ला date sheets वरील seatbelt समजा — manager विचारण्यापूर्वी वापरा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, NETWORKDAYS को date sheets पर seatbelt समझो — manager पूछे उससे पहले इस्तेमाल करो.
Download practice file: practice-networkdays.xlsx (includes sheet About this data, practice sheets, and Answers).
Worked examples
1) October 2026 workdays
Pune sprint.
| Start | End |
|---|---|
| 2026-10-01 | 2026-10-31 |
Result: 22
What it means: Weekdays in October 2026 inclusive.
2) Minus holiday 2 Oct
Gandhi Jayanti.
| Start | End | Holiday |
|---|---|---|
| 2026-10-01 | 2026-10-31 | 2026-10-02 |
Result: 21
What it means: One Friday holiday removed.
3) Short window
Dublin € milestone.
| Start | End | € |
|---|---|---|
| 2026-10-05 | 2026-10-09 | 500 |
Result: 5
What it means: Mon–Fri only inside the window.
4) Same day Friday
One-day job.
| D |
|---|
| 2026-10-02 |
Result: 1
What it means: A Friday counts as one workday.
5) Weekend-only span
Sat–Sun.
| Start | End |
|---|---|
| 2026-10-03 | 2026-10-04 |
Result: 0
What it means: No weekdays → 0.
6) Reverse dates
End before start.
| Start | End |
|---|---|
| 2026-10-31 | 2026-10-01 |
Result: -22
What it means: Excel returns negative when end < start.
Common errors and fixes
Notes and tips
- Revisit NETWORKDAYS 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: count October workdays with and without 2 Oct from memory.
- NETWORKDAYS vs NETWORKDAYS.INTL: classic Sat–Sun vs custom weekend patterns.
- Fictional sample data only.
- Print the NETWORKDAYS revision card.
- Ask juniors to predict before Enter.
- Track your top mistake monthly.
- Project plans in Pune IT and Dublin agencies count delivery days.
- Excel stores dates as serials.
- Verify with a known calendar before long chains.
- Print the revision card for NETWORKDAYS 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, 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: count October workdays with and without 2 Oct from memory. Project plans in Pune IT and Dublin agencies count delivery days. Classroom drill: write three brand-new NETWORKDAYS 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 vs NETWORKDAYS.INTL: classic Sat–Sun vs custom weekend patterns.
Interview corner
- Include holidays?
- Third argument range.
- Custom weekend?
- NETWORKDAYS.INTL.
- Why not end-start?
- That counts calendar days.
Related functions
NETWORKDAYS.INTL, WORKDAY, DATEDIF
Practice tasks (10)
- Task 1. Workdays 1–31 Oct 2026.Two dates.
- Task 2. Exclude 2 Oct.Third arg.
- Task 3. Count Mon–Fri 5–9 Oct.Short.
- Task 4. Same-day Friday.Equal.
- Task 5. Show weekend span = 0.Sat Sun.
- Task 6. Explain negative reverse.Order.
- Task 7. List two holidays in a range.Range.
- Task 8. Compare calendar days vs workdays.Subtract dates.
- Task 9. Doc default weekend.Note.
- Task 10. Bonus: switch to INTL for Fri+Sat.Related.
Quick quiz
Answers: Q1=Sat+Sun, Q2=Optional range of dates, Q3=0, Q4=Negative count, Q5=NETWORKDAYS.INTL (check after you try).
Revision card
Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.
