Common WORKDAY.INTL questions usually focus on argument format, unexpected results, and filling formulas across multiple cells; this FAQ covers 3 common question groups.
FAQ
Why does WORKDAY.INTL show a #VALUE! error?
- Check whether
start_date,days, orweekendcontains text or invalid characters. - Make sure the date cell uses a valid date format instead of plain text.
- If the data was pasted from another source, remove extra spaces or re-enter the arguments.
Why is the result different from what I expected?
- Check whether the
weekendargument matches your actual workweek rule. - Confirm that the
holidaysreference range contains complete dates in the correct format. - Review whether
daysis positive or negative. Positive values count forward, and negative values count backward.
How do I use WORKDAY.INTL in multiple cells?
- Enter the full WORKDAY.INTL formula in the first target cell.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag downward or copy and paste the formula into other target cells, then review the reference style.
Glossary
| Term | Definition |
|---|---|
| start_date | The starting date used for the workday calculation. |
| weekend | The argument that defines which days are treated as weekends, using either a number or a seven-character string. |
| holidays | A date range or array of holiday dates excluded from the workday calculation. |