NETWORKDAYS.INTL
TheNETWORKDAYS.INTL
formula calculates the number of workdays between two dates, excluding weekends and any specified holidays. This formula is commonly used in financial and project management spreadsheets to calculate the duration of a project or to determine the number of workdays in a given period.
 How to use
NETWORKDAYS.INTL
formula?  Examples of using
NETWORKDAYS.INTL
formula NETWORKDAYS.INTL
formula not working? Similar formulas to
NETWORKDAYS.INTL
Usage
Use the NETWORKDAYS.INTL
formula with the syntax shown below, it has 2 required parameters and 2 optional parameters:
 start_date (required):
The start date of the period for which you want to calculate workdays.  end_date (required):
The end date of the period for which you want to calculate workdays.  weekend (optional):
An optional parameter that specifies which days of the week are considered weekends. By default, weekends are Saturday and Sunday. You can use a number or string to represent the weekend days, where 1 or '0000001' represents Monday, 2 or '0000010' represents Tuesday, and so on. You can also use a string of '0000011' to represent Saturday and Sunday as the weekend days.  holidays (optional):
An optional range or array of dates that represent holidays, which are excluded from the calculation of workdays.
Examples
Here are a few example use cases that explain how to use theNETWORKDAYS.INTL
formula in Google Sheets.
Calculate the number of workdays in a month
To calculate the number of workdays in a month, you can use the NETWORKDAYS.INTL
formula to subtract the number of weekends and holidays from the total number of days in the month. For example, =NETWORKDAYS.INTL("20220101", "20220131", "0000011")
calculates the number of workdays in January 2022, assuming Saturday and Sunday are weekends.
Calculate the duration of a project
To calculate the duration of a project in workdays, you can use the NETWORKDAYS.INTL
formula to subtract the number of weekends and holidays from the total number of days between the start and end dates. For example, =NETWORKDAYS.INTL(A2, B2, "0000011", holidays)
calculates the number of workdays between the start date in cell A2 and the end date in cell B2, excluding Saturdays and Sundays and any holidays listed in the range "holidays".
Calculate the number of workdays until a deadline
To calculate the number of workdays until a deadline, you can use the NETWORKDAYS.INTL
formula to subtract the number of weekends and holidays from the total number of days between today's date and the deadline. For example, =NETWORKDAYS.INTL(TODAY(), "20221231", "0000011", holidays)
calculates the number of workdays until December 31, 2022, excluding Saturdays and Sundays and any holidays listed in the range "holidays".
Common Mistakes
NETWORKDAYS.INTL
not working? Here are some common mistakes people make when using the NETWORKDAYS.INTL
Google Sheets Formula:
Incorrect date format
Make sure that the start_date and end_date arguments are formatted as dates and are entered correctly. Common errors include using text instead of dates or entering the dates in the wrong order.
Incorrect weekend argument
The weekend argument should be a number or a string that specifies which days of the week are considered weekends. Make sure you are using the correct format and that the argument is entered correctly. Common errors include using the wrong number or string format, or omitting the argument entirely.
Incorrect holidays argument
The holidays argument should be a range of cells that contains the dates of holidays. Make sure you are using the correct format and that the argument is entered correctly. Common errors include using the wrong range or omitting the argument entirely.
Related Formulas
The following functions are similar to NETWORKDAYS.INTL
or are often used with it in a formula:

NETWORKDAYS
The
NETWORKDAYS
function returns the number of working days between two given dates. This function excludes weekends (Saturday and Sunday) and optionally, any specified holidays. This function is commonly used in financial and business applications to calculate the number of workdays between two dates. 
WORKDAY
The
WORKDAY
function returns a date that is a specified number of workdays (excluding weekends and holidays) away from a given start date. This function is useful for calculating a project deadline or delivery date. The function takes the start date and the number of workdays to add to the start date. Additionally, you can specify a range of holiday dates to exclude from the calculation. 
DATEDIF
The
DATEDIF
function in Google Sheets calculates the difference between two dates using a specified unit of measurement. This function is commonly used to calculate the length of time between two dates, such as the number of days, months, or years. The function is particularly useful when working with financial or project planning data. 
WEEKDAY
The
WEEKDAY
formula takes a given date and returns the day of the week it represents, as a number ranging from 1 (Sunday) to 7 (Saturday). This function is most commonly used to calculate the day of the week for a given date and to perform calculations or comparisons based on the day of the week.
Learn More
You can learn more about the NETWORKDAYS.INTL
Google Sheets function on Google Support.