Ravindra BagaleCourses & study guides Track your progress

Excel WORKDAY.INTL Function

By · Last updated:

Chala mitrano — today WORKDAY.INTL. Shift by working days when the weekend is not Sat–Sun.

Fictional sample data for learning. Pune team delivering to a Fri+Sat weekend client in Dubai. Mixed ₹ and AED-style practice amounts.

Purpose

Like WORKDAY, but with a custom weekend pattern.

Return value

A date serial.

Syntax

WORKDAY.INTL(start_date, days, [weekend], [holidays])

Arguments

ArgumentRequired?Description
start_dateRequiredStart.
daysRequiredWorkdays to shift.
weekendOptionalCode or 7-char mask Mon→Sun. 7 = Fri+Sat.
holidaysOptionalHoliday range.

Version

Excel 2010+; Microsoft 365. LibreOffice offers WORKDAY.INTL.

How to use — Why → What → How

Why: Same SLA maths as WORKDAY, but the client’s weekend differs. Pune team delivering to a Fri+Sat weekend client in Dubai. In Indian back offices and foreign sister teams, WORKDAY.INTL shows up on leave, SLA and invoice sheets every week.

What: WORKDAY.INTL uses weekend codes/masks like NETWORKDAYS.INTL. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =WORKDAY.INTL(A2,5,7).
  2. Document code 7 = Fri+Sat.
  3. Add holidays as the 4th argument.

Ravindra Bagale's Tip

Friends, after you learn WORKDAY.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 WORKDAY.INTL and rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

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

Ravindra Bagale's Tip

Friends, after you finish WORKDAY.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 WORKDAY.INTL like a seatbelt on date sheets — use it before a manager asks why the deadline slipped.

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

Worked examples

1) +5 with weekend 7

Dubai SLA from Pune.

StartAmount
2026-10-01400
Formula: =WORKDAY.INTL(A2,5,7)

Result: 2026-10-08

What it means: Skips Fri+Sat while counting 5 workdays.

2) Compare to WORKDAY

Same start/days.

Start
2026-10-01
Formula: =TEXT(WORKDAY(A2,5),"yyyy-mm-dd")&" vs "&TEXT(WORKDAY.INTL(A2,5,7),"yyyy-mm-dd")

Result: 2026-10-08 vs 2026-10-08

What it means: Different weekends → different due dates.

3) With holiday

Skip 8 Oct.

StartHol
2026-10-012026-10-08
Formula: =WORKDAY.INTL(A2,5,7,B2)

Result: 2026-10-11

What it means: Holiday pushes further.

4) Backward

Prep deadline.

Deadline
2026-10-15
Formula: =WORKDAY.INTL(A2,-3,7)

Result: 2026-10-12

What it means: Three custom workdays earlier.

5) Sunday-only mask

Rare pattern.

Start
2026-10-01
Formula: =WORKDAY.INTL(A2,3,"0000001")

Result: 2026-10-05

What it means: Only Sunday is weekend.

6) Legend row

Document codes.

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

Result: keep legend on sheet

What it means: Prevents silent wrong SLAs.

Common errors and fixes

#NUM! — Bad weekend code. Fix: Fix code/mask.
#VALUE! — Bad dates. Fix: Fix types.
Wrong due — Forgot code 7. Fix: Write legend.

Notes and tips

  • Revisit WORKDAY.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: due dates for a Fri+Sat client without peeking.
  • WORKDAY.INTL vs WORKDAY: custom weekend vs Sat–Sun.
  • Fictional sample data only.
  • Print the WORKDAY.INTL revision card.
  • Ask juniors to predict before Enter.
  • Track your top mistake monthly.
  • Pune team delivering to a Fri+Sat weekend client in Dubai.
  • Excel stores dates as serials.
  • Verify with a known calendar before long chains.
  • Print the revision card for WORKDAY.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 WORKDAY.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: due dates for a Fri+Sat client without peeking. Pune team delivering to a Fri+Sat weekend client in Dubai. Classroom drill: write three brand-new WORKDAY.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

WORKDAY.INTL vs WORKDAY: custom weekend vs Sat–Sun.

Interview corner

When INTL?
Non Sat–Sun weekends.
Code 7?
Fri+Sat.
Holidays?
4th argument.

WORKDAY, NETWORKDAYS.INTL

Practice tasks (10)

  1. Task 1. +5 with code 7 from 1 Oct.
    INTL.
  2. Task 2. Compare WORKDAY.
    Both.
  3. Task 3. Add holiday.
    4th.
  4. Task 4. Write legend.
    Doc.
  5. Task 5. Negative shift.
    Neg.
  6. Task 6. Explain client weekend.
    Interview.
  7. Task 7. Sunday-only mask.
    Mask.
  8. Task 8. Format Date.
    Fmt.
  9. Task 9. Teach code 7.
    Teach.
  10. Task 10. Bonus: NETWORKDAYS.INTL pair.
    Related.

Quick quiz

Q1. INTL adds:
Q2. Code 7:
Q3. vs WORKDAY:
Q4. Mask length:
Q5. Holidays:

Answers: Q1=Custom weekend, Q2=Fri+Sat, Q3=Weekend control, Q4=7, Q5=4th arg (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: WORKDAY.INTL
WORKDAY.INTL revision card