NETWORKDAYS.INTL Function in Excel: Syntax, Examples and Free Practice
NETWORKDAYS.INTL is an Excel Date & Time function. Counts working days between two dates with a custom weekend.
NETWORKDAYS.INTL syntax
Arguments
start_date: The date to start counting fromend_date: The date to count up toweekend: Which days count as the weekend (optional)holidays: A list of dates to exclude as holidays (optional)
When to use NETWORKDAYS.INTL
NETWORKDAYS.INTL is used in scheduling, deadline tracking, and reporting that spans specific date ranges.
Practice NETWORKDAYS.INTL online, free
Open the live Excel-style spreadsheet and try NETWORKDAYS.INTL yourself. No Excel install or sign-up needed to start.
Practice NETWORKDAYS.INTL now →More Date & Time functions
Frequently asked questions
What does the NETWORKDAYS.INTL function do in Excel?
Counts working days between two dates with a custom weekend.
What is the syntax of NETWORKDAYS.INTL in Excel?
The syntax is =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]). start_date: The date to start counting from; end_date: The date to count up to; weekend: Which days count as the weekend (optional); holidays: A list of dates to exclude as holidays (optional).
Where can I practice NETWORKDAYS.INTL online for free?
Open the free live spreadsheet on Cellgrids and try NETWORKDAYS.INTL 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