Menu
EXCEL WORKDAYS FUNCTION
Excel WORKDAYS Function Introduction
This method produces a date based on the number of working days before or after a date that you give (the starting date). For future dates, use a positive number, while for previous dates, use a negative number. Weekends are excluded by default when using WORKDAY (Saturday and Sunday).
For example, the result of =WORKDAY(“01/01/2016”,3) is 42375, which is the serial number of the day 06-01-16. The 1st of January is a Friday, the 4th of January is a Monday, and the 5th of January is a Tuesday. Since the second parameter is 3, you will receive the fourth workday day as a response, which is the 6th of January 2016.
Description of Excel WORKDAYS Function
Syntax:
=WORKDAY (start_date, days, [holidays])
Parameter list:
- start date – the date to begin with.
- days – The number of working days prior to or following start date.
- holidays – [optional] The following is a list of dates that should be regarded non-working days.
Step By Step Guide of WORKDAYS Function
Example :
Key Points
- Dates are stored as consecutive serial numbers in Microsoft Excel so that they may be utilised in computations. January 1, 1900 is serial number 1 by default, and January 1, 2008 is serial number 39448 since it is 39,448 days after January 1, 1900.
- WORKDAY returns the #VALUE! error value if any of the arguments is not a valid date.
- If the result of start date + days is an incorrect date, WORKDAY returns the #NUM! error value.
- Days is shortened if it is not an integer.
Excel VLOOKUP Function Template/Exercise
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
