WORKDAY(TODAY(), 2) : The date two business days in the future. If today is a Wednesday, the date would be Friday; if today is Thursday, the date would be Monday; if today is Friday, the date would be Tuesday.

WORKDAY(TODAY(), 5) : Five business days (one business week) in the future.

WORKDAY(TODAY(), -5) : Five business days (one business week) in the past.

WORKDAY("12/1/2019", 25, LIST("12/24/2019", "12/25/2019", "1/1/2020")) : 1/8/2020

WORKDAY([Project Start], [Est Days], Holidays[Date]) : Computes a project's anticipated end date from its known start date and an estimated number of days of work, taking into account known holidays.


WORKDAY( when , days [ , holidays ] )


  • when (Date)

  • days (Number) : A number of workdays by which to adjust when. May be positive or negative. Note that a value of zero (0) is a special case and will produce the original date.

  • holidays (list of Date) : An optional list of dates that are not considered workdays.

Return Value

Date: The date computed by adjusting when by days workdays. A "workday" is any Monday through Friday, excluding any dates specified by the optional holidays list.

Note that if days is zero (0), the original value of when is returned unchanged.

See Also


Did this answer your question?