NETWORKDAYS.INTL

• 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:

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

1. start_date (required):
   The start date of the period for which you want to calculate workdays.
2. end_date (required):
   The end date of the period for which you want to calculate workdays.
3. 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.
4. holidays (optional):
   An optional range or array of dates that represent holidays, which are excluded from the calculation of workdays.

Examples

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("2022-01-01", "2022-01-31", "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(), "2022-12-31", "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

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.