Function: WORKDAY.INTL()

🔍 Purpose:

The WORKDAY.INTL() function is an advanced version of WORKDAY() that lets you customize which days are weekends.
It’s ideal for countries, businesses, or industries that don’t follow the standard Saturday–Sunday weekend pattern.

For example:

• In India, most offices follow Saturday–Sunday weekends.

• In the Middle East, weekends are Friday–Saturday.

• Some schools may only have Sunday off.

🧮 Syntax:  =WORKDAY.INTL(start_date, days, [weekend], [holidays])


Parameters:

• start_date: Starting date for calculation.

• days: Number of working days to move forward or backward.

• [weekend]: (Optional) Defines which days are weekends.

• [holidays]: (Optional) A range or list of dates to exclude.

📅 Weekend Codes Reference Table

Example: (Custom Weekend for Indian Company)

Scenario:
An IT company in Hyderabad gives Friday–Saturday off instead of Saturday–Sunday.
They want to calculate the delivery date for a 7-day project starting on 6-Jan-2025.

👉 Formula:

✅ Result: 16-Jan-2025
Because Excel skips Friday and Saturday as non-working days.

📘 Example (With Holidays)

➡ Here:

• Weekends are Sunday only (11)

• Holidays are 14-Jan and 26-Jan
  The result excludes all Sundays and listed holidays.

🎯 5 Real-Life Project Scenarios

🧮 Project 1: School Timetable Planning (Education Scenario)

Objective:
Calculate the next class test date, considering that schools have Sunday only off.

👉 Formula:
=WORKDAY.INTL(A2,B2,C2,{"15-Feb-2025","21-Feb-2025"})

📚 Goal: The school auto-calculates upcoming test dates excluding Sundays & holidays.

💼 Project 2: Company Shift Scheduler (Corporate Scenario)

Objective:
A logistics company works Tuesday–Sunday, with Monday as the only off day.
Calculate project deadlines for each team.

👉 Formula:
=WORKDAY.INTL(A2,B2,C2,{"26-Jan-2025","15-Feb-2025","21-Feb-2025"})

🚛 Goal: Helps companies with non-traditional weekends manage shift-based projects accurately.

🕌 Project 3: Middle East Project Planning (International Scenario)

Objective:
A construction company in Dubai wants to calculate delivery dates with Friday–Saturday weekends and public holidays.

👉 Formula:
=WORKDAY.INTL(A2,B2,C2,{"26-Jan-2025"})

🏗️ Goal: Used by companies working in the Middle East where weekends differ from India.

🧾 Project 4: Hospital Staff Duty Roster (Healthcare Scenario)

Objective:
Hospitals operate 6 days a week with Friday only off.
We need to calculate the next duty rotation date for doctors.

👉 Formula:
=WORKDAY.INTL(B2,C2,D2,{"26-Jan-2025"})

🏥 Goal: Automate shift cycles by skipping hospital off-days and holidays.

🚢 Project 5: Shipping & Logistics Deadline (Import/Export Scenario)

Objective:
A shipping company runs from Monday to Friday only (weekend: Saturday–Sunday).
They need to calculate cargo arrival dates, excluding both weekends and port holidays.

👉 Formula:
=WORKDAY.INTL(A2,B2,C2,{"10-Feb-2025","15-Feb-2025","21-Feb-2025"})

🚢 Goal: Ensures delivery timelines account for both weekends and national port closures.

🧠 Key Insights:

✅ WORKDAY.INTL() is essential when your working week is customized.
✅ Combine it with TODAY() for rolling future date calculations:

➡ Calculates the date 7 working days ahead, skipping Friday–Saturday weekends.
✅ Perfect for international offices, custom shifts, and academic calendars.