Formulas > =WORKDAY.INTL()

How To Use WORKDAY.INTL() Function in Google Sheets


Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

Common questions about the WORKDAY.INTL formula include:

1. What is the syntax of the formula?
2. How do I use the formula to calculate a date in a different country or region?
3. What arguments should be included in the formula?

The WORKDAY.INTL formula can be used to calculate the number of non-consecutive working days between two dates, taking into account locale-specific holidays and weekend days. It is typically used to calculate project deadlines, calculation of difference between two dates, and creation of a calendar view of events.

The WORKDAY.INTL formula can be commonly mistyped as WORKDAY, WORKDAYINTL, and INTL.

Common ways the WORKDAY.INTL formula is used inappropriately include not specifying all the arguments the formula requires, including incorrect arguments in the formula, or not setting up the correct locale code when inputting weekend days.

Common pitfalls when using the WORKDAY.INTL formula include forgetting to include all required arguments, using incorrect arguments, forgetting to specify the locale code, or forgetting to use absolute references when including the start and end dates. 

Common mistakes when using the WORKDAY.INTL formula include forgetting to put in the proper arguments, misstyping the formula, or including extra parameters in the list of arguments. 

Common misconceptions people may have with the WORKDAY.INTL Formula are that it is only used to calculate business days, or that it is a formula for calculating the number of days between two dates. In reality, the formula is more versatile and can be used to take into account holidays and other non-working days, depending on the settings used.

How To Actually Use WORKDAY.INTL() in Sheets

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

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the WORKDAY.INTL() formula:

Date Functions in Excel & Google Sheets Tutorial

This tutorial covers date math in spreadsheet applications, how to use date formulas & functions in Excel & Google Sheets. Functions covered: NETWORKDAYS.INTL, WORKDAY.INTL, DATEDIF, WEEKNUM, EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, TEXT, DATEVALUE, TODAY, NOW, DAYS.

Generate a WORKDAY.INTL() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.