WORKDAY Function in Excel

The WORKDAY function in Excel takes a date as input and returns the nearest working day in the future or past, based on days value you provide. You can also exclude holidays

Syntax for WORKDAY Function in Excel

WORKDAY (start_date, days, [holidays])

 start_date – The date from which to start.

days – working days before or after start_date.

holidays – [optional] A list dates that should be considered non-working days.

 

Example of WORKDAY Function in Excel

Formula

WORKDAY Function in Excel 1

  • 23rd working day (excluding weekend) from Jan-1-2017 is Feb-1-2017
  • 15th working day in reverse from Jan-1-2017 is Dec-12-2017

So the result will be

Result

WORKDAY Function in Excel 2

 

Example of WORKDAY Function in Excel with holiday list

Formula

WORKDAY Function in Excel 3

  • 23rd working day (excluding weekend) and Excluding list of holidays from Jan-1-2017 is Feb-3-2017

So the result will be

Result

 WORKDAY Function in Excel 4

previous-small WORKDAY Function in Excel                                                                                                          next_small WORKDAY Function in Excel