WORKDAY function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax. This function was introduced in Excel 2007 and is built in later versions. For use in versions earlier than Excel 2007, Analysis ToolPak needs to be enabled.
=WORKDAY( Start_Date,Days,Holiday )
- Start_Date:- A date in a valid excel format. Can be entered using DATE function; if dates in form of text are entered then there is a possibility of getting an error.
- Days:- It is number of days in future or past of Start_Date.
- Holidays:- Days which are non-working.
- In General formatting of Excel, Dates are in form of serial numbers. Serial number 1 is for 1 JAN, 1900 and the number increases from thereon. For getting it in readable form use the formatting function.
- A valid Excel date must be used, Otherwise #VALUE! error is displayed.
- If non integer days are supplied , they are trimmed
- Start Date is not incorporated when calculating the End Date.
Here is an example of WORKDAY function which has workday result in column C and formatted result in column D. It also has a list of holidays in column F to G.