NETWORKDAYS Function in Excel: Syntax, Examples and Free Practice
NETWORKDAYS is an Excel Date & Time function. Counts working days between two dates, excluding weekends.
NETWORKDAYS syntax
Arguments
start_date: The date to start counting fromend_date: The date to count up toholidays: A list of dates to exclude as holidays (optional)
When to use NETWORKDAYS
NETWORKDAYS is used in scheduling, deadline tracking, and reporting that spans specific date ranges.
Practice NETWORKDAYS online, free
Open the live Excel-style spreadsheet and try NETWORKDAYS yourself. No Excel install or sign-up needed to start.
Practice NETWORKDAYS now →Learn more
Read the tutorial: Working days with NETWORKDAYS.
More Date & Time functions
Frequently asked questions
What does the NETWORKDAYS function do in Excel?
Counts working days between two dates, excluding weekends.
What is the syntax of NETWORKDAYS in Excel?
The syntax is =NETWORKDAYS(start_date, end_date, [holidays]). start_date: The date to start counting from; end_date: The date to count up to; holidays: A list of dates to exclude as holidays (optional).
Where can I practice NETWORKDAYS online for free?
Open the free live spreadsheet on Cellgrids and try NETWORKDAYS yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts