Excel

NETWORKDAYS.INTL: Excel Formulae Explained

How do you use NETWORKDAYS.INTL in Excel?

The NETWORKDAYS.INTL function in Excel calculates the number of working days between two dates. The function takes into account weekends and holidays. To use the function, enter the start date and end date in the cells below, and then select the "Calculate" button. The function will return the number of working days between the two dates.

What is the syntax of NETWORKDAYS.INTL in Excel?

The syntax of NETWORKDAYS.INTL in Excel is as follows: NETWORKDAYS.INTL(start_date,end_date,holidays)

start_date - The start date of the calculation. This can be a date string, a reference to a cell containing a date, or a serial number.

end_date - The end date of the calculation. This can be a date string, a reference to a cell containing a date, or a serial number.

holidays - (Optional) An array of date strings, references to cells containing dates, or serial numbers representing the dates of the holidays. If this argument is omitted, then all holidays are assumed to be on the same day.

What is an example of how to use NETWORKDAYS.INTL in Excel?

The NETWORKDAYS.INTL function in Excel calculates the number of days between two dates, excluding weekends and holidays. The function takes into account the defined holiday list, which you can customize to include the holidays that are important to you. To use the function, enter the following into a cell:

=NETWORKDAYS.INTL(start_date, end_date, holiday_list)

For example, if you want to calculate the number of days between January 1, 2019 and January 5, 2019, you would enter the following into a cell:

=NETWORKDAYS.INTL(1/1/2019, 1/5/2019, "USA")

This would return a result of 4, since January 1, 2019 and January 5, 2019 are both Saturday, and are therefore not counted as days in the calculation.

When should you not use NETWORKDAYS.INTL in Excel?

There are a few occasions when you should not use the NETWORKDAYS.INTL function in Excel. First, if you have a date range that includes February 29th, the function will not work correctly, as February 29th is not a working day. Additionally, if you have a date range that crosses a date change, such as December 31st, the function will not work correctly.

What are some similar formulae to NETWORKDAYS.INTL in Excel?

Formulas that calculate the number of days between two dates are NETWORKDAYS.INTL, DATEDIF, and DAYS. In Excel, NETWORKDAYS.INTL is the most versatile, as it can account for both working and non-working days. To use NETWORKDAYS.INTL, you need to specify the start date, end date, and the type of calculation. The type of calculation can be either "workday" or "non-workday". If you select "workday", then NETWORKDAYS.INTL will ignore weekends and holidays. If you select "non-workday", then NETWORKDAYS.INTL will include weekends and holidays. DATEDIF is simpler to use than NETWORKDAYS.INTL, as it only has two calculation options: "days" and "months". DAYS is the simplest of the three, as it just calculates the number of days between two dates.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.