WORKDAY

  • Updated

Returns a date adjusted by a number of working days from a specified start date.

Sample Usage

WORKDAY(C5,30)
WORKDAY(DATE(2020,5,5), 30, A1:A10)

Syntax

WORKDAY(start_date, days, [holidays])

  • start_date - The start_date to consider.
  • days- The number of working days before or after start_date.
  • holidays - [OPTIONAL] A list of dates to exclude from the working calendar.

Examples

WORKDAY(C5,30) returns the date 30 workdays from the start date mentioned in C5.
WORKDAY(DATE(2020,5,5), 30, A1:A10) returns the date 30 workdays from the start date after excluding holidays A1:A10.

 

Notes

  • WORKDAY does not auto-convert number formats. Therefore, WORKDAY(10/10/2000) is interpreted as WORKDAY(0.05) , the quotient of 10 divided by 10 divided by 2000.
  • WORKDAY calculates the number of work days between two dates. To calculate the working day a specific number of days ahead of a date, use NETWORKDAYS.