Date & Time
WORKDAY.INTL Function in Excel
Returns the date after a specified number of workdays with custom weekend parameters.
Syntax
- =WORKDAY.INTL(start_date, days, [weekend], [holidays])
Arguments
- start_date (required): Start date
- days (required): Number of workdays
- weekend (optional): Weekend days (1-7 or string)
- holidays (optional): Holiday dates to exclude
Examples
- =WORKDAY.INTL("1/1/2024", 10, 1) - 10 workdays from date - Result: 1/15/2024
Excel WORKDAY.INTL function documentation
- WORKDAY.INTL returns date n workdays away with custom weekend definition.
- Syntax: =WORKDAY.INTL(start_date, days, [weekend], [holidays]).
- Essential for locales with Fri-Sat or Sun-only weekends and global project plans.
- Related: [WORKDAY](/functions/workday/), [NETWORKDAYS.INTL](/functions/networkdays-intl/), [EDATE](/functions/edate/).
WORKDAY.INTL weekend argument
- weekend code 1-17 or 11-digit string — which days are non-work.
- Code 1 = Sat+Sun default like WORKDAY.
- Code 11 string example "0000011" Fri+Sat off — Middle East patterns.
- holidays optional range of dates to skip.
Step-by-step: due date 10 business days Fri-Sat weekend
- Step 1 — Start date in A2, days 10 in B2.
- Step 2 — =WORKDAY.INTL(A2, B2, 7) code 7 = Fri+Sat weekend (verify code table in Excel help).
- Step 3 — Add holiday range as fourth argument.
- Step 4 — Format result as date.
- Step 5 — Pair with [NETWORKDAYS.INTL](/functions/networkdays-intl/) to validate day count.
WORKDAY.INTL vs WORKDAY vs calendar tables
- WORKDAY — Sat-Sun weekend only.
- WORKDAY.INTL — configurable weekends.
- Manual holiday table — flexible but fragile.
- Date hub: [/categories/date-time/](/categories/date-time/).
Worked examples to copy
- Standard: =WORKDAY.INTL(TODAY(), 5, 1).
- Custom string: =WORKDAY.INTL(A2, 10, "0000011", holidays).
- Negative days: =WORKDAY.INTL(A2, -5, 1) go backward.
- With holiday named range: Holidays2026.
People also ask
- WORKDAY.INTL weekend codes? — See Excel help table; wrong code wrong calendar.
- WORKDAY.INTL holidays? — Third/fourth arg skips those dates.
- WORKDAY.INTL vs PROJECT? — Excel not MS Project — no resource calendars.
- WORKDAY.INTL Google Sheets? — WORKDAY.INTL similar in Sheets.
Common errors
- Weekend parameter varies by region
Use cases
- International scheduling
- Custom work weeks
- Deadline calculation
Frequently asked questions
- What is WORKDAY.INTL used for? WORKDAY.INTL calculates a date that is a specified number of working days from a start date, with customizable weekends. Perfect for international project planning where weekends vary by country or for businesses with non-standard work weeks.
- How do I calculate deadline with Friday-Saturday weekend? Use =WORKDAY.INTL(start_date, days, 7) where 7 means Friday-Saturday weekend. For 10 working days from today with Middle East weekend: =WORKDAY.INTL(TODAY(), 10, 7). Add holidays as 4th parameter.
- How do I handle a 4-day work week? Use the string format: =WORKDAY.INTL(start, days, "0001111") for Mon-Thu work week (Fri-Sun off). Each character represents Mon-Sun; 1=non-working, 0=working. This handles any custom schedule.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use WORKDAY.INTL
- International scheduling — common Date & Time scenario for WORKDAY.INTL.
- Custom work weeks — common Date & Time scenario for WORKDAY.INTL.
- Deadline calculation — common Date & Time scenario for WORKDAY.INTL.
WORKDAY.INTL in the Date & Time category
- Browse all Date & Time functions at /categories/date-time/ for related formulas.
- WORKDAY.INTL syntax: =WORKDAY.INTL(start_date, days, [weekend], [holidays])
- start_date (required): Start date
- days (required): Number of workdays
- weekend (optional): Weekend days (1-7 or string)
- holidays (optional): Holiday dates to exclude
- Confirm WORKDAY.INTL arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm WORKDAY.INTL arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- WORKDAY (/functions/workday/): Returns a date that is a specified number of working days before or after a start date.
- NETWORKDAYS.INTL (/functions/networkdays-intl/): Returns the number of whole workdays between two dates with custom weekend parameters.
- EDATE (/functions/edate/): Returns a date that is a specified number of months before or after a given date.
Errors to watch for
- Weekend parameter varies by region — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter WORKDAY.INTL on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
WORKDAY.INTL worked examples to copy
- =WORKDAY.INTL("1/1/2024", 10, 1) — 10 workdays from date. Expected result: 1/15/2024.
WORKDAY.INTL reference summary for crawlers and offline review
- WORKDAY.INTL belongs to the Date & Time category in Excel. Returns the date after a specified number of workdays with custom weekend parameters.
- Full syntax: =WORKDAY.INTL(start_date, days, [weekend], [holidays]). Open /functions/workday-intl/ for parameters, FAQs, and related pages.
- Common mistakes: Weekend parameter varies by region
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.