# WORKDAY.INTL function

WORKDAY.INTL is a function in Microsoft Excel that calculates the date that falls a specified number of working days in the future or past, considering a custom set of non-working days (weekends and holidays). This function is useful for tasks like project planning and scheduling.

## Syntax

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

## How to Use

Let’s walk through how to use the WORKDAY.INTL function with a few examples:

Example 1: Calculate a date 10 working days after a given start date:

This formula will return a date 10 working days after November 3, 2023, considering the default weekend (Saturday and Sunday) as non-working days.

Example 2: Calculate a date 5 working days before a given start date, considering a custom weekend that excludes Fridays:

In this example, the formula calculates a date 5 working days before November 3, 2023, treating only Friday as a non-working day.

Example 3: Calculate a date 15 working days ahead, excluding specific holiday dates:

Here, the formula finds a date 15 working days from November 3, 2023, without considering any weekends as non-working days, and excluding the dates listed in cells A1 to A3 as holidays.

Example 4: Calculate a date 7 working days after a specified start date, treating the default weekend as non-working, but with additional holidays:

In this case, the formula computes a date 7 working days after November 3, 2023, treating Saturday and Sunday as non-working days, and also excluding the dates listed in cells A1 to A3 as holidays.