How to Use the WORKDAY.INTL Function in Excel
Today, we’re going to explore how to use the WORKDAY.INTL function in Microsoft Excel and Google Sheets. This function is designed to calculate a future or past date from a specified starting date, accounting for working days only and optionally excluding weekends and listed holidays.
Understanding the Syntax
The syntax for the WORKDAY.INTL function is as follows:
WORKDAY.INTL(start_date, days, [weekend], [holidays])- start_date: The date from which the calculation will begin.
- days: The number of working days to add (if positive) or subtract (if negative) from the start_date.
- weekend: This optional parameter allows you to define which days of the week should be treated as weekends. By default, this is set to 1, which treats Saturday and Sunday as non-working days. You can modify this according to your region’s workweek by using different numerical codes.
- holidays: Another optional argument, this is a range of cells that contain dates which should be recognized as non-working holidays.
Examples of Usage
To better understand the practical applications of the WORKDAY.INTL function, let’s go through some examples:
| Formula | Description | Result |
|---|---|---|
=WORKDAY.INTL("6/1/2022", 10) |
Add 10 working days to June 1, 2022, with the default weekend setting. | June 15, 2022 |
=WORKDAY.INTL("6/1/2022", -5) |
Subtract 5 working days from June 1, 2022, using the standard weekend days. | May 25, 2022 |
=WORKDAY.INTL("6/1/2022", 5, 11) |
Add 5 working days to June 1, 2022, with only Sunday counted as the weekend (code 11). | June 8, 2022 |
=WORKDAY.INTL("6/1/2022", 7, 1, B2:B6) |
Add 7 working days to June 1, 2022, while excluding the holidays listed in cells B2 to B6. | June 10, 2022 |
The examples provided showcase how the WORKDAY.INTL function can be adeptly used to manage deadlines, calculate project schedules, or adjust dates based on specific working day requirements by customizing weekend parameters and accounting for holidays.
With this powerful function, you can effectively manage timelines, gauge completion dates for tasks, and optimize your scheduling efforts in Excel and Google Sheets.
More information: https://support.microsoft.com/en-us/office/workday-intl-function-a378391c-9ba7-4678-8a39-39611a9bf81d