Check Sheet Logo
Check Sheet

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.

Usage

Use the NETWORKDAYS formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:

=NETWORKDAYS(start_date, end_date, [holidays])
Parameters:
  1. 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.
  2. 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.
  3. 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 the NETWORKDAYS 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 non-numeric values in holidays range

Make sure the holidays range only contains valid date values, as any non-numeric values or text will cause errors in the formula.

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 non-working 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.