Excel WORKDAY() Function
Excel WORKDAY() Function
The WORKDAY() function in excel returns the serial number of the date before or after a specified number of workdays.
Syntax
WORKDAY (START_DAY, DAYS, [HOLIDAYS])
Parameter
START_DAY (required)- This parameter represents the initial date from which you have to start calculating the working days.
DAYS(optional)- This parameter represents the end date.
HOLIDAY (required)- This parameter represents a list of one or more dates that should be considered non-work days.
Category
Date & Time
Return
This function returns the serial number of the date before or after a specified number of workdays.
Example 1
Objective: Add 90 working days to 'Dummy Dates' and return in the result cell
Holidays | Date |
New Year's Day | 1-Jan-18 |
Republic Day | 26-Jan-18 |
Good Friday | 14-Apr-18 |
Idul Fitr | 26-Jun-18 |
Independence Day | 15-Aug-18 |
Vijaya Dashmi | 30-Sep-18 |
Gandhi Jayanti | 2-Oct-18 |
Deepawali | 18-Oct-18 |
Christmas Day | 25-Dec-18 |
Dummy Dates | Days/Answer | Date/Formatted Value | Formula Used |
1-Jan-16 | 42496 | 6-May-16 | =WORKDAY (B8,90, $G$14:$G$22) |
20-Sep-17 | 43125 | 25-Jan-18 | =WORKDAY (B9,90, $G$14:$G$22) |
21-Mar-17 | 42941 | 25-Jul-17 | =WORKDAY (B10,90, $G$14:$G$22) |