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])

Arguments

start_dateThe initial date from which you want to start counting working days.
daysThe number of working days to add or subtract from the start_date. Use a positive number for future dates and a negative number for past dates.
[weekend](Optional): An optional parameter that specifies which days of the week are considered non-working. This argument uses a 7-character string, where each character represents a day of the week (M, T, W, H, F, S, U). For example, “0000011” considers Saturday and Sunday as non-working days.
[holidays](Optional): An optional range of cells that contains a list of holiday dates you want to exclude from the calculation. These holidays are additional non-working days.

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.

Additional Information

WORKDAY.INTL is a versatile function that allows you to calculate dates while considering various workweek and holiday scenarios. It’s particularly helpful in business and project management to determine deadlines and schedules. Keep in mind that the function is available in Microsoft Excel and may not be supported in other spreadsheet software.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.