Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

WORKDAYS.INTL

Find a number of working days between a date range in Excel
Returns the number of whole workdays between two dates.

Rational

Get Nthworking day before and after a given date with custom weekend days.

Description

The Excel WORKDAYS.INTL returns a working day before and after a date, excluding custom Weekend days. Example; to find a working day 2 days after a date (01-11-2018- cell B7) excluding Friday and Saturday, use =WORKDAY.INTL(B7,2,7), that returns ‘05-11-2018’.

Moreover, an optional argument (holidays) can also exclude holidays, vacation time, and so on.

Syntax

= WORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Parameters

start_date – The Start date.
weekend [optional] – Setting custom weekend days
holidays [optional] – A list of additional days to be excluded apart from weekends.

Return Value

Working date as per arguments.

Key Notes

  • The WORKDAY.INTL function returns the nearest working day after excluding weekend days (Saturdays and Sundays as default).
  • The result includes the start_date as the first date for calculating return value. The second argument for the WORKDAY function can be positive or negative for calculating future or past dates respectively.
  • The WORKDAY.INTL function was introduced with the Excel 2010 providing a higher degree of freedom compared to the WORKDAY formula.
  • As with all dates in Excel, what you end up with is a serial number, but the Date formatting displays the date in a readable fashion.
  • The weekend is an optional argument to select customize weekend number or string that specifies when a weekend occurs in a week to excel.

Weekend number value indicates the following weekend days:

Return_typeNumber returned
1 or omittedNumbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Microsoft Excel.
2Numbers 1 (Monday) through 7 (Sunday).
3Numbers 0 (Monday) through 6 (Sunday).
11Numbers 1 (Monday) through 7 (Sunday).
12Numbers 1 (Tuesday) through 7 (Monday).
13Numbers 1 (Wednesday) through 7 (Tuesday).
14Numbers 1 (Thursday) through 7 (Wednesday).
15Numbers 1 (Friday) through 7 (Thursday).
16Numbers 1 (Saturday) through 7 (Friday).
17Numbers 1 (Sunday) through 7 (Saturday).

To find previous day when you do work use WORKDAYS.INTL function. for example, =WORKDAYS.INTL(10 June 2019,-8) it return 30 May 2019. it means to find last day work we will write date in negative form (-8).

Same you can apply for next work day only remove negative sign from days and if there are holiday you can exclude the days by putting the days in holiday parameter.

Keep Reading Similar Functions:

Get Nth working day before and after a given date in Excel

WORKDAY

WORKDAY function returns a date based on a given number of working days before and after starting date, to find two days after a date excl. weekends,=WORKDAY(date,2) returns 2.

Read More »
Find a number of working days between a date range in Excel

NETWORKDAYS

The NETWORKDAYS function returns a number of working days between two dates, 01-11-2018 (B6) and 31-12-2018 (C6), use =NETWORKDAYS(B6,C6) that returns ‘43’.

Read More »
Get a date by entering the year, month, and day in Excel

DATE

The DATE function returns a date value using year, month and date, sequentially. I.e.; to merge all 3 date component, =DATE(2012,12,4) returns “04-12-2012”.

Read More »