# NETWORKDAYS.INTL

The `NETWORKDAYS.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.

## Usage

Use the `NETWORKDAYS.INTL` formula with the syntax shown below, it has 2 required parameters and 2 optional parameters:

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

Here are a few example use cases that explain how to use the `NETWORKDAYS.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("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

`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.

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.

You can learn more about the `NETWORKDAYS.INTL` Google Sheets function on Google Support.