Excel Function

WORKDAY

Returns date shifted by working days.

WORKDAY(start_date, days, [holidays])

Arguments

start_date

Required

Enter a date/reference-related value.

days

Required

Enter a numeric value.

holidays

Optional

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

Practice Preview

calculate and display date/time values. Use WORKDAY to Returns date shifted by working days. 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. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=WORKDAY(B2, 5, D2:D5)

Practice This Function

Practice in Sequential Mode Back to Function List