The WORKDAY.INTL function in Google Sheets is a powerful tool designed for project management and scheduling. This function calculates a date that occurs a specified number of workdays from a given start date, while also allowing users to define which days of the week should be treated as weekends and to exclude holidays. This flexibility makes it ideal for various business scenarios and personal planning.

Syntax

WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

• start_date: The date from which to start counting.
• num_days: The number of workdays to add to the start date.
• weekend (optional): A string or number representing which days are considered weekends (default is Saturday and Sunday).
• holidays (optional): A range or array of dates to be considered as holidays and excluded from the workday calculations.

Example #1

WORKDAY.INTL("2023-01-01", 10)

This function adds 10 workdays to January 1, 2023, treating Saturday and Sunday as weekends. The resulting date would be January 15, 2023.

Example #2

WORKDAY.INTL("2023-01-01", 15, "0000011")

Here, the function adds 15 workdays to January 1, 2023, using a custom weekend of Friday and Saturday. The resulting date would be January 25, 2023.

Example #3

WORKDAY.INTL("2023-01-01", 10, 1, {"2023-01-05", "2023-01-12"})

In this example, the function adds 10 workdays to January 1, 2023, treating Sunday as the only weekend day and excluding January 5 and January 12 as holidays. The resulting date would be January 16, 2023.

Error handling

• VALUE!: This error occurs if the start_date is not a valid date or if num_days is not a number.
• NUM!: This error happens if the calculated result falls outside the allowable date range.
• N/A: This error may appear if items in the holidays array are not valid date values.

Conclusion

The WORKDAY.INTL function is an invaluable asset for businesses and individuals who need to manage timelines, ensuring that project schedules remain realistic and compliant with custom weekend definitions and holidays. By mastering this function, users can significantly enhance their planning capabilities within Google Sheets.