Wauvel

Excel like a finance pro.

← The library

Date function

WORKDAY

Returns the date a number of working days from a start date.

Very commonDifficulty 1150 · ProficientUsage rank #75 of 520
Practice · 4 questions →

When to use it

The date a number of working days before or after a start date, skipping weekends and listed holidays. Due dates and delivery promises.

The shape of it

Syntax
=WORKDAY(start_date, days, [holidays])

Worked examples

  • Next working day

    =WORKDAY(DATE(2025,3,14),1) → 3/17/2025

    One working day after a Friday is Monday.

  • Ten days out

    =WORKDAY(DATE(2025,3,3),10) → 3/17/2025

    Ten working days after Monday March 3.

  • With holidays

    =WORKDAY(A2,5,Holidays) → 3/12/2025

    Five working days after A2, skipping holidays.

Worth knowing

  • The start date itself is not counted; WORKDAY(date,0) returns the date even on a weekend.
  • Negative days go backwards.
  • WORKDAY.INTL for custom weekends.

Where it goes wrong

  • Result is a serial until formatted.
  • A start date on a weekend is not adjusted forward for zero days.

Related

TODAYDATEMONTHYEARNOWDAY

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.