How to Use WORKDAY.INTL Function

The WORKDAY.INTL function is to return a number that represents a date before or after a number of working days with custom weekend parameters.

Formula:

= WORKDAY.INTL(start_date, days, [weekend], [holidays])

Explanations:

  • Start_date is required, the start date.
  • Days is required. The number of nonweekend and nonholiday days before or after start_date: a positive value for a future date; a negative value for a past date.
  • [Holidays] is optional, the list of one or more holiday dates to exclude from the working calendar.
  • [Weekend] is optional, a weekend number or string that specifies when weekends occur.

Cautions:

  • By default, Microsoft Excel uses January 1, 1900 as serial number 1.
  • WORKDAY.INTL returns the #NUM! error when holiday is out of range for the current date base value.

Example 1: After 50 working days, January 18, 2016 will be March 16, 2016, if only Monday as weekend.

=WORKDAY.INTL(A2,B2,12)

Example 2: After 50 working days, January 18, 2016 will be March 17, 2016, if only Monday as weekend, and not to count the holidays.

=WORKDAY.INTL(A3,B3,12,C3)

Example 3: After 50 working days, January 18, 2016 will be March 17, 2016, if Monday and Tuesday as weekends, and not to count the holidays.

=WORKDAY.INTL(A4,B4,3,C3:C4)

Download: WORKDAY.INTL Function

Leave a Reply