WORKDAY.INTL
The WORKDAY.INTL function in Google Sheets is a powerful tool to calculate the date after a specified number of workdays excluding specified weekend days and holidays. Whether you're tracking project deadlines, scheduling events, or planning vacations, the WORKDAY.INTL function simplifies the task. Dive into our comprehensive guide to master its application.
Function Syntax and Parameters
Syntax: WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Parameters:
start_date: The starting date from which to calculate.num_days: The number of workdays to add or subtract fromstart_date.weekend: [Optional] A number or string indicating which days are considered weekends. Defaults to Saturday and Sunday.holidays: [Optional] A range or array of dates considered as holidays.
Step-by-Step Tutorial
-
Calculating the date after a specified number of workdays:
- Example:
=WORKDAY.INTL(DATE(2022, 1, 1), 10, 1, B2:B10) - Result: Returns the date 10 workdays after January 1, 2022, excluding Sundays and dates in the range B2:B10.
- Example:
-
Calculating the date before a specified number of workdays:
- Example:
=WORKDAY.INTL(DATE(2022, 1, 31), -5, 1, B2:B10) - Result: Returns the date 5 workdays before January 31, 2022, excluding Sundays and dates in the range B2:B10.
- Example:
Use Cases and Scenarios
- Project Management: Determine the deadline for a task considering workdays and excluding holidays.
- Event Planning: Calculate the date of an event after a specific number of workdays, excluding weekends and holidays.
- Vacation Planning: Find the end date of a vacation by adding a certain number of workdays, excluding weekends and public holidays.
Related Functions
WORKDAY: Calculate the date after a specified number of workdays.NETWORKDAYS: Calculate the number of working days between two dates.NETWORDDAYS.INTL: Calculate the number of working days between two dates excluding specified weekend days and holidays.