Excel WORKDAY.INTL() Function

Excel WORKDAY.INTL() Function

The WORKDAY.INTL() function in excel returns a date before or after a specified number of workdays with custom weekend parameter.

Syntax

WORKDAY.INTL (START_DAY, DAYS,[WEEKEND],[HOLIDAYS])

Parameter

START_DAY (required)- This parameter represents the initial date from which you have to start calculating the working days.

DAYS(required)- This parameter represents the date end.

WEEKEND(optional)- This Setting for which days of the week should be considered weekends. The options are as follows:

  1 signifies Saturday, Sunday

  2 signifies Sunday, Monday

  3 signifies Monday, Tuesday

  4 signifies Tuesday, Wednesday

  5 signifies Wednesday, Thursday

  6 signifies Thursday, Friday

  7 signifies Friday, Saturday

11 signifies Sunday only

12 signifies Monday only

13 signifies Tuesday only

14 signifies Wednesday only

15 signifies Thursday only

16 signifies Friday only

17 signifies Saturday only

HOLIDAY (optional)- This parameter represents a list of one or more dates that should be considered non-work days.

Category

Date & Time

Return

This function returns a date before or after a specified number of workdays with a custom weekend parameter.

Example 1

Objective: Add 90 working days to 'Dummy Dates' where weekends are Thursday and Friday 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 42494 4-May-16 =WORKDAY.INTL (B8,90, 6, $G$14:$G$22)  
20-Sep-17 43127 27-Jan-18 =WORKDAY.INTL (B9,90,6, $G$14:$G$22)  
21-Mar-17 42941 25-Jul-17 =WORKDAY.INTL (B10,90, 6, $G$14:$G$22)  



ADVERTISEMENT
ADVERTISEMENT