Function 13: NETWORKDAYS.INTL()

📘 Definition:

The NETWORKDAYS.INTL() function calculates the number of working days between two dates, allowing you to define which days are weekends.

Unlike NETWORKDAYS(), this version gives full flexibility — perfect for India, where some companies (like private firms or schools) may consider Sunday only, while others treat Saturday–Sunday, or even Friday–Saturday as weekends.

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


🧠 Example (Indian Perspective):

📊 Example Table:

✅ Explanation:

• When only Sunday is weekend (code 11), you get 26 working days instead of 22.

• This is more realistic for many Indian private offices or schools that work on Saturdays.

💡 Tip:

You can also use a 7-character binary string to define custom weekends:

👉 Each digit represents a day from Monday to Sunday (1 = weekend, 0 = workday).
Example: "0000011" means Saturday and Sunday are weekends.

🎯 Why It’s Useful:

• Useful for organizations with different weekends (e.g., banks, IT firms, schools).

• Great for HR, Payroll, and Project Planning across branches in different states.

• Supports real Indian working patterns, where Saturday might be a half-day or working day.

🧑‍💻 Project Task 1: Branch-wise Working Day Comparison

👉 Tasks:

1. Use the formula:

    

   =NETWORKDAYS.INTL(B2,C2,D2,E2)


2. Find out which branch had maximum working days.

3. Create a bar chart comparing all branches’ total working days.

4. Add conditional formatting to highlight any branch with less than 20 days.

🧑‍💻 Project Task 2: Student Exam Preparation Tracker

👉 Tasks:

1. Use =NETWORKDAYS.INTL(B2,C2,D2,E2) to calculate study days excluding weekends and festivals.

2. Find out who got the highest number of effective study days.

3. Create a ranking system using =RANK(F2,F2:F5,0) for best preparation advantage.