WORKDAY.INTL Function in Google Sheets

Calculate a workday, allowing for custom weekends, using the WORKDAY.INTL function.

WORKDAY.INTL Function

The WORKDAY.INTL function in Google Sheets calculates a workday that is a specific number of days from a start date, allowing for custom weekend parameters.

Syntax

WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
  • start_date: The date from which to start the calculation.
  • num_days: The number of workdays to add (can be negative).
  • weekend (optional): A string or number that specifies which days of the week are weekends.
  • holidays (optional): A range or array of dates considered as holidays.

Examples

  1. Basic Usage

To find the date 10 workdays from "2024-08-15", with a weekend of Friday and Saturday:

=WORKDAY.INTL("2024-08-15", 10, "1100000")
  1. Including Holidays

To include holidays in A2:A5 and use a standard weekend:

=WORKDAY.INTL("2024-08-15", 10, 1, A2:A5)

Notes

  • The weekend parameter can be a string (e.g., "1100000") or a number (e.g., 1 for Saturday/Sunday).
  • Useful for international businesses with different working days.
  • NETWORKDAYS.INTL: Counts workdays between dates, considering custom weekends.
  • EDATE: Calculates a date a specified number of months before or after a given date.