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
- 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
Example of WORKDAY Function in Excel with holiday list
Formula
- 23rd working day (excluding weekend) and Excluding list of holidays from Jan-1-2017 is Feb-3-2017
So the result will be
Result