NETWORKDAYS + IF Function in Excel: Syntax, Examples and Free Practice
NETWORKDAYS + IF is an Excel Date & Time function. Counts working days between two dates using NETWORKDAYS, then classifies the result with IF.
NETWORKDAYS + IF syntax
Arguments
start_date: Start of the periodend_date: End of the period
When to use NETWORKDAYS + IF
Flagging support tickets that have been open for more than a working week.
Practice NETWORKDAYS + IF online, free
Open the live Excel-style spreadsheet and try NETWORKDAYS + IF yourself. No Excel install or sign-up needed to start.
Practice NETWORKDAYS + IF now →More Date & Time functions
Frequently asked questions
What does the NETWORKDAYS + IF function do in Excel?
Counts working days between two dates using NETWORKDAYS, then classifies the result with IF.
What is the syntax of NETWORKDAYS + IF in Excel?
The syntax is =IF(NETWORKDAYS(start_date, end_date)>5, "Over a Week", "Within a Week"). start_date: Start of the period; end_date: End of the period.
Where can I practice NETWORKDAYS + IF online for free?
Open the free live spreadsheet on Cellgrids and try NETWORKDAYS + IF 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