Quick Navigation
WORKDAY.INTL Function
Summary
The WORKDAY.INTL function calculates dates that are a specified number of working days before or after a start date, with customizable weekend definitions. This advanced date function lets you define which days count as weekends, making it perfect for international scheduling and custom work calendars.
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| start_date | Date |
Yes | Starting date from which to calculate workdays (dates are truncated to integers) |
| days | Number |
Yes | Number of workdays to add (positive) or subtract (negative); zero returns start_date |
| weekend | Number or String |
No | Weekend pattern: 1-17 codes or 7-char string (0=workday, 1=weekend). Omits to Sat-Sun. |
| holidays | Date Range/Array |
No | Optional list of holiday dates to exclude from workdays |
Using the WORKDAY.INTL Function
WORKDAY.INTL extends the standard WORKDAY function by allowing custom weekend definitions, essential for global teams or industries with non-standard workweeks. Use numeric codes 1-17 for common patterns or create custom 7-character strings for unique schedules.
Common WORKDAY.INTL Examples
Standard Weekend (Sat-Sun)
=WORKDAY.INTL(DATE(2023,1,1),10)Returns date 10 workdays after Jan 1, 2023, assuming Saturday-Sunday weekend (default)
Sunday-Only Weekend
=WORKDAY.INTL("1/15/2023",15,11)Calculates 15 workdays from Jan 15, treating only Sundays as non-workdays
Custom Weekend String
=WORKDAY.INTL(DATE(2023,6,1),20,"0000011",A1:A5)20 workdays from June 1 with Fri-Sat weekend (0000011) excluding holidays in A1:A5
Past Workdays
=WORKDAY.INTL(TODAY(),-5,1)Finds date 5 workdays before today (standard Sat-Sun weekend)
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: start_date or holidays contain invalid dates outside Excel's date range
Solution: Ensure all dates are valid Excel dates (1/1/1900 to 12/31/9999)
#VALUE!
Cause: weekend string is wrong length or contains invalid characters (not 0 or 1)
Solution: Use exactly 7 characters with only 0s and 1s. Avoid all 1s (1111111).
#NUM!
Cause: Invalid weekend number (0 or outside 1-17 range)
Solution: Use weekend codes 1-17 or omit for default Sat-Sun
Notes
- Positive days count forward, negative backward from start_date
- Dates are automatically truncated to integers
- Weekend code 1 (or omitted) = Saturday-Sunday
- String patterns start with Monday (position 1) through Sunday (position 7)
- All-1s string (1111111) is invalid - must have at least one workday
- Works with dynamic arrays in Excel 365
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2007 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+