Skip to content
Klargrid

The WORKDAY function

A delivery date 10 working days out, not counting weekends or holidays.

Syntax

=WORKDAY(start_date, days, [holidays])

In a French Excel: =SERIE.JOUR.OUVRE(date_départ; nb_jours; [jours_fériés]).

Arguments

  • start_date: the starting date, not counted.
  • days: the working days to add; negative to go back.
  • holidays: a range of dates to skip.

An example

=WORKDAY(A2,10,Holidays!$A$2:$A$12)

The date 10 working days after A2, holidays excluded.

Pitfalls

  • Excel knows no public holiday: you have to list them.
  • Another weekend (Friday and Saturday): WORKDAY.INTL.

Going further

Frequently asked questions

How do I know whether a date is a working day?
=WORKDAY(A2-1,1)=A2 returns TRUE for a working day.