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)  



ADVERTISEMENT
ADVERTISEMENT