WORKDAY.INTL
Returns the date that is a given number of working days before or after a start date, with custom weekend parameters. Like WORKDAY but lets you specify which days are weekends.
WORKDAY.INTL(start_date, days, [weekend], [holidays])Arguments
start_dateThe start date.daysNumber of working days before (negative) or after (positive) the start date.weekendOptional. Number 1-17 or a 7-character 0/1 string defining the weekend. 1 = Sat/Sun (default), 11 = Sun only, etc.(optional)holidaysOptional. A range of dates to exclude as non-working days.(optional)
=WORKDAY.INTL("2026-01-01",10)10 working days after Jan 1, 2026 (Sat/Sun weekend)
=WORKDAY.INTL("2026-01-01",10,7)Same calculation but treating Friday/Saturday as weekend
=WORKDAY.INTL("2026-01-01",10,"0000011")Custom weekend pattern via binary string
- •Available since Excel 2010
- •Format the result as a date — Excel returns a serial number
- •Use a 7-char binary string like "0000011" for custom weekend patterns (Mon=position 1)
- •Combines well with EOMONTH and DATE for advanced project scheduling
- •Using the numeric weekend codes (1-17) without checking Excel's reference table first - the numbers don't follow an obvious pattern, so guessing can easily select the wrong weekend definition
- •Building the 7-character binary weekend string in the wrong day order - position 1 represents Monday, not Sunday, which trips up anyone assuming a Sunday-first week
- •Forgetting that the result is a date serial number that needs date formatting applied - without it, the cell displays a plain number instead of a readable date
WORKDAYUses a fixed Saturday/Sunday weekend, a simpler alternative when the standard convention already fits your needs.NETWORKDAYS.INTLCalculates the number of working days between two dates, the inverse operation of WORKDAY.INTL's date-projection.EOMONTHOften combined with WORKDAY.INTL when scheduling formulas need to account for month-end boundaries alongside custom weekends.How do I choose the right weekend code number?
Check Excel's documentation table rather than guessing - the codes 1 through 17 map to specific weekend day combinations that aren't in an intuitive order.
Why does my WORKDAY.INTL result show as a plain number instead of a date?
The function returns a date serial number, which needs to be formatted as a date to display properly - apply date formatting to the cell if it isn't already set.
Can WORKDAY.INTL calculate a date before the start date?
Yes, use a negative value for the days argument to count backward from start_date instead of forward.
Need to translate a formula using WORKDAY.INTL?
Use our translator to convert your complete formula