WORKDAY calculates a future or previous working date while excluding weekends.

Syntax:

=WORKDAY(start_date,days,[holidays])

Example

Start Date: 28-Sep-2026
Working Days: 10

=WORKDAY(A2,10)

Excel calculates the date after 10 working days, excluding weekends.

Excluding Holidays

If holidays are listed in H2:H4:

=WORKDAY(A2,10,H2:H4)

Real-World Applications

  • Project deadlines
  • Delivery dates
  • Employee task deadlines
  • Service deadlines
  • Assignment submission dates
PreviousNext