Google Sheets WORKDAY.INTL Function: Syntax, Examples & Tips

start_date:
The date from which to start counting the number of working days. This should be a valid date value.

num_days:
The number of working days to add to the start_date. This can be a positive or negative integer.

weekend:
(Optional) A string or number that specifies which days of the week are considered weekends. If omitted, the default is Saturday and Sunday.

holidays:
(Optional) A range of one or more dates that should be considered as non-working days in addition to weekends. This can be a single date, an array of dates, or a range of cells containing dates.

What is WORKDAY.INTL?

The WORKDAY.INTL function in Google Sheets is a specialized tool used to calculate a date that is a specified number of working days from a start date, while also allowing for customization of which days are considered weekends. This function is particularly useful for project management, scheduling, and any scenario where you need to account for non-working days in your calculations.

In simpler terms, WORKDAY.INTL helps you find future dates while skipping weekends and holidays based on your specific requirements.

A Practical Example

Imagine you are managing a project timeline and need to determine the end date based on the number of working days allocated for each task:

Project Timeline Table:

You want to calculate the end date for each task, considering that your weekends are Saturday and Sunday.

WORKDAY.INTL Formula

To achieve this, you would use the WORKDAY.INTL function as follows:

=WORKDAY.INTL(C2, D2, "0000011")

In this formula:

• C2 is the cell containing the StartDate from the Project Timeline Table.
• D2 is the cell containing the number of WorkingDays for the task.
• "0000011" is the weekend parameter, where "0" indicates a working day and "1" indicates a weekend day (in this case, Saturday and Sunday).

Result of the Formula

When you apply the WORKDAY.INTL formula to the Project Timeline Table, the output would look like this:

In this case, Task A starts on October 1, 2023, and ends on October 6, 2023, while Task B ends on October 13, 2023, after accounting for the weekends.

Why Use WORKDAY.INTL?

WORKDAY.INTL is beneficial because it provides flexibility in defining weekends, making it suitable for various business calendars. It simplifies the process of calculating future dates while considering non-working days, which is essential for accurate project planning and scheduling.

Key Takeaways:

• WORKDAY.INTL: A Google Sheets function that calculates a date a specified number of working days from a start date, with customizable weekends.
• Flexibility: Allows you to define which days are considered weekends, accommodating different business needs.
• Project Management: Ideal for scheduling tasks, project timelines, and any scenario where working days need to be calculated.
• Error Handling: Automatically adjusts for weekends, ensuring accurate date calculations.

WORKDAY.INTL is an essential function for anyone involved in project management or scheduling, providing a powerful way to enhance planning and efficiency.

Happy spreadsheeting!