NETWORKDAYS Function

Returns the number of working days between two dates.
Sample Usage
NETWORKDAYS([Due Date]4, [Due Date]5)
Syntax
NETWORKDAYS(
  • start_date
  • end_date
  • [
    holidays
    ]
)
  • start_date
    —
    The first date to be measured.
  • end_date
    —
    The last date to be measured.
  • holidays
    —[optional]
    The dates to exclude from the count.
Usage Notes
  • WORKDAY, NETWORKDAY, and NETWORKDAYS count Saturday and Sunday as non-working days. If dependencies are enabled on your sheet you can customize the non-working days, and the formulas will use your settings in calculations.
Related Functions
WORKDAY
NETWORKDAY
NETDAYS
Was this article helpful?
YesNo