WORKDAYINTL

  • Updated

Returns a date adjusted by a number of working days from a specified start date, excluding specified weekend days and holidays.

Sample Usage

WORKDAYINTL(C5,30)
WORKDAYINTL(DATE(2020,5,5), 30, 2, A1:A10)

Syntax

WORKDAYINTL(start_date, days, [weekends], [holidays])

  • start_date - The start_date to consider.
  • days- The number of working days before or after start_date.
  • weekends - [OPTIONAL] A number or string representing which days of the week are considered weekends.
    • Weekends can be specified using a string comprising of 0’s and 1’s, where a zero means that the day is a work day, and a 1 means that the day is a weekend. The first number in the set represents Monday. So, “0000011” would mean Saturday and Sunday are weekends.
    • You can also specify the weekend pattern using a single number.
      • 1 = Saturday and Sunday are weekends
      • 2 = Sunday and Monday are weekends and so on until
      • 7 = Friday and Saturday are weekends.
      • 11 = Sunday is the only weekend
      • 12 = Monday is the only weekend and so on until
      • 17 = Saturday is the only weekend.
  • holidays - [OPTIONAL] A list of dates to consider as holidays.

Examples

WORKDAYINTL(C5,30) returns the date 30 workdays from the start date mentioned in C5.
WORKDAYINTL(DATE(2020,5,5), 30, 2, A1:A10) returns the date 30 workdays from the start date after excluding weekends and holidays specified in A1:A10.

Notes

  • WORKDAYINTL does not auto-convert number formats. Therefore, WORKDAYINTL(10/10/2000) is interpreted as WORKDAYINTL(0.05) , the quotient of 10 divided by 10 divided by 2000.
  • If you specify the weekends as a string, make sure that you enclose the string in quotation marks. 
  • WORKDAYINTL is similar to WORKDAY, but it allows weekend days to be specified for areas where Saturday and Sunday are not considered the weekend.
  • WORKDAYINTL calculates the number of work days between two dates. To calculate the working day a specific number of days ahead of a date, use NETWORKDAYS.INTL.