WORKDAY.INTL

Summary

Returns the date serial that is a given number of workdays from a start date, with configurable weekends.

Remarks

• Positive days moves forward; negative days moves backward.
• The weekend argument can be a number code (1-7, 11-17) or a 7-character string of 0s and 1s (Mon-Sun, 1 = weekend day). Default is 1 (Sat/Sun).
• The optional holidays argument accepts a range or array of date serials to exclude.
• A weekend string of all 1s (no workdays) returns #VALUE!.

Examples

Related functions

• WORKDAY
• NETWORKDAYS.INTL
• WEEKDAY
• DAYS360
• NETWORKDAYS
• YEARFRAC

FAQ

What is the difference between WORKDAY and WORKDAY.INTL?

WORKDAY.INTL adds a weekend parameter that lets you define which days are non-working, instead of always using Saturday/Sunday.

Runtime metadata