How do I count business days between two dates in Excel?

Use =NETWORKDAYS(start_date, end_date) to count working days excluding weekends. Add a holiday list as the third argument: =NETWORKDAYS(start, end, Holiday_List).

What is the difference between NETWORKDAYS and NETWORKDAYS.INTL?

NETWORKDAYS excludes Saturday and Sunday by default. NETWORKDAYS.INTL lets you specify which days are the weekend - useful for regions with a Friday-Saturday or other weekend convention.

How do I create a holiday list for the NETWORKDAYS formula?

Enter your public holiday dates in a column in Excel date format, name that range (e.g. Holiday_List using Ctrl+F3), and reference the named range in the NETWORKDAYS formula.

Count Working Days Between Dates in Excel

This task is powered by the =NETWORKDAYS() Excel function, and can come in handy when creating project work plans or Gantt charts. The syntax is below: =NETWORKDAYS(start-date, end-date, [number of ho...

This task is powered by the =NETWORKDAYS() Excel function, and can come in handy when creating project work plans or Gantt charts. The syntax is below:

=NETWORKDAYS(start-date, end-date, [number of holidays] )

If the national or public holidays for the duration of the project are known, these can be entered into excel as a list, as shown below. Ensure the dates are in Excel date format: Blog31

Name the range containing the list (e.g "Holiday_List"), and refer to that range in the =NETWORKDAYS() function so that the holidays can be taken into account in the formula

=NETWORKDAYS(E6, F6, Holiday_List)

Count Working Days Between Two Dates in Excel (Excluding Weekends & Holidays)

Frequently Asked Questions