Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
WORKDAY.INTL
WORKDAY.INTL extends WORKDAY by letting you define which days count as the weekend using a numeric code or a 7-character binary string (1=non-workday). This makes it ideal for regions with Friday–Saturday weekends, four-day work weeks, or any non-standard schedule.
Excel
=WORKDAY.INTL(DATE(2024,1,1),10,11)Google Sheets
=WORKDAY.INTL(DATE(2024,1,1),10,11)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| StartDate | Days | WeekendCode | Result |
| 2024-01-01 | 10 | 11 | |
| 2024-03-01 | 5 | 7 | |
| 2024-06-17 | 8 | 11 | |
| 2024-11-25 | 4 | 7 |
=WORKDAY.INTL(DATE(2024,1,1),10,11)→45303
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Place your start date in A2 and number of work days in B2.
- 2Choose a weekend code: e.g. 11 = Sunday-only weekend, 7 = Friday–Saturday.
- 3Type =WORKDAY.INTL(A2,B2,11) and add an optional holidays range as a fourth argument.
Need a version for your data?
Try: “Calculate business day deadlines for a country where only Sunday is a day off”