Returns the date of a working day that is a specified number of days before or after a start date, excluding weekends and optional holidays.
=WORKDAY.INTL(start_date, days, [weekend], [holidays])Describe what you need. The generator will reach for WORKDAY.INTL where WORKDAY.INTL is the right tool, and tell you when it is not.
| Argument | Required | Description |
|---|---|---|
| start_date | Required | The beginning date from which to count working days; accepts date values, text in recognized date format, or cell references. |
| days | Required | The number of working days to add (positive) or subtract (negative); non-integer values are truncated. |
| weekend | Optional | Optional parameter specifying which days are weekends (1–7 where 1=Sat-Sun, 6=Fri-Sat, etc.); defaults to 1 if omitted. |
| holidays | Optional | Optional range or array of dates to exclude as holidays in addition to weekend days; individual holiday dates are skipped regardless of day-of-week. |
A date value representing a future or past working day.
Excel: All · Google Sheets: Supported
| Vehicle | Odometer | Service Date | Cost | Garage |
| Van A | 45000 | 2024-01-15 | 850 | North |
| Truck B | 62000 | 2024-01-18 | 1200 | South |
=WORKDAY.INTL(B2, 30)Result: 2024-02-16
Van A's last service was January 15, 2024. Using WORKDAY.INTL to add 30 working days automatically skips weekends, returning February 16 as the next scheduled preventive maintenance appointment.
| Vehicle | Odometer | Service Date | Cost | Garage |
| Truck B | 62000 | 2024-01-18 | 1200 | South |
| Van C | 32000 | 2024-02-02 | 720 | East |
=WORKDAY.INTL(B3, 5, 6)Result: 2024-01-24
Truck B servicing begins January 18 at the South garage, located in the Middle East where Friday-Saturday is the weekend. The weekend parameter 6 specifies this calendar, and adding 5 working days gives January 24 (Wednesday) as the service completion deadline.
| Vehicle | Odometer | Service Date | Cost | Garage | Holidays | 2024-02-19 | |
| Van A | 48500 | 2024-02-22 | 650 | North | 2024-03-17 | ||
| Truck B | 65200 | 2024-03-01 | 950 | East |
=WORKDAY.INTL(B4, 10, 1, H2:H3)Result: 2024-03-06
Van A's February 22 service will be followed by a 10-working-day checkup. When excluding company holidays (February 19 and March 17) in addition to weekends, the next maintenance check is scheduled for March 6, ensuring no scheduling conflicts with company closures.
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | start_date is not recognized as a valid date (e.g., text without proper formatting, corrupted cell), or days is not numeric (e.g., text like 'thirty' instead of 30). | Verify start_date is a real date value and use DATE() or DATEVALUE() if needed. Ensure days is a number. Example: =WORKDAY.INTL(DATEVALUE('2024-01-15'), 30). |
| #NUM! | The weekend parameter is outside the valid range 1–7, or specifies an invalid configuration (e.g., 0, 8, or -1). | Use only weekend values 1 through 7. Consult your spreadsheet's documentation for the correct mapping (1=Sat-Sun, 2=Sun-Mon, 6=Fri-Sat). Example: =WORKDAY.INTL(B2, 30, 6). |
| #REF! | The holidays range reference is broken—cells have been deleted, the range was moved, or the reference points outside the workbook. | Verify the holidays range exists and contains valid dates. Use a named range (Data > Named Ranges) for robustness. Example: =WORKDAY.INTL(B2, 30, 1, CompanyHolidays). |
The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.
Open the formula generatorReviewed 2026-09-17