Excel Function

WORKDAY.INTL

Returns workday-based date with customizable weekends.

WORKDAY.INTL(start_date, days, [weekend], [holidays])

Arguments

start_date

Required

Enter a date/reference-related value.

days

Required

Enter a numeric value.

weekend

Optional

Set weekend pattern with codes 1-7 / 11-17, or a 7-character string such as "0000011".

holidays

Optional

Specify a reference range. You can drag or click start/end cells.

Practice Preview

calculate and display date/time values. Use WORKDAY.INTL to Returns workday-based date with customizable weekends. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use 5 for days, use 1 for weekend. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=WORKDAY.INTL(B2, 5, 1, D2:D5)

Practice This Function

Practice in Sequential Mode Back to Function List