NETWORKDAYS
TheNETWORKDAYS
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.
 How to use
NETWORKDAYS
formula?  Examples of using
NETWORKDAYS
formula NETWORKDAYS
formula not working? Similar formulas to
NETWORKDAYS
Usage
Use the NETWORKDAYS
formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:
 start_date (required):
The start date that marks the beginning of the period for which to calculate the number of workdays. This parameter must be a valid date in a format recognized by Google Sheets.  end_date (required):
The end date that marks the end of the period for which to calculate the number of workdays. This parameter must be a valid date in a format recognized by Google Sheets.  holidays (optional):
An optional range or array of dates that represent the holidays that should be excluded from the calculation. This parameter must be a range or array of dates in a format recognized by Google Sheets.
Examples
Here are a few example use cases that explain how to use theNETWORKDAYS
formula in Google Sheets.
Calculate the number of workdays between two dates
You can use NETWORKDAYS
to calculate the number of workdays (excluding weekends and holidays) between two given dates. This is useful for financial and business applications where you need to calculate the number of workdays between two dates.
Calculate the number of workdays in a month
You can use NETWORKDAYS
together with other functions such as EOMONTH
to calculate the number of workdays in a given month. This is useful for payroll and scheduling applications where you need to calculate the number of workdays in a month.
Calculate the number of workdays until a deadline
You can use NETWORKDAYS
to calculate the number of workdays until a deadline, such as a project delivery date or a tax filing deadline. This is useful for project management and tax planning applications where you need to calculate the number of workdays until a deadline.
Common Mistakes
NETWORKDAYS
not working? Here are some common mistakes people make when using the NETWORKDAYS
Google Sheets Formula:
Incorrect date format
Make sure the start_date and end_date arguments are valid dates in the correct format (e.g. using the DATE function or entering them in a recognized date format).
Missing arguments
Make sure you include the start_date and end_date arguments, and optionally the holidays argument if needed.
Incorrect arguments order
Make sure the start_date and end_date arguments are in the correct order (start_date first, end_date second).
Invalid holidays range
Make sure the holidays argument is a valid range of cells in the same format as the start_date and end_date arguments, or a list of recognized date values.
Using nonnumeric values in holidays range
Make sure the holidays range only contains valid date values, as any nonnumeric values or text will cause errors in the formula.
Related Formulas
The following functions are similar to NETWORKDAYS
or are often used with it in a formula:

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. 
WORKDAY.INTL
The
WORKDAY.INTL
formula calculates the date that is a specified number of workdays away from a given starting date, using custom weekend parameters and an optional list of holiday dates. This formula is commonly used to calculate due dates or project deadlines, taking into account nonworking days such as weekends and holidays. 
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. 
YEARFRAC
The
YEARFRAC
function calculates the fraction of a year between two dates. This is useful for calculating the duration of time periods that are less than a year. The function takes into account leap years and can use different day count conventions to calculate the fraction of a year.
Learn More
You can learn more about the NETWORKDAYS
Google Sheets function on Google Support.