NETWORKDAYS function in Excel

Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

Common mistakes

• Forgetting NETWORKDAYS counts both the start and end date.
• Mixing up WEEKDAY numbering: use 2 so Monday = 1.

Related date functions

• DATEBuilds a date from year, month and day.
• TODAYReturns today's date.
• DATEDIFDifference between two dates in "Y", "M" or "D".
• DAYSNumber of days between two dates.
• EDATEDate a number of months before or after.
• EOMONTHLast day of the month, months away.
• WORKDAYDate a number of working days away.
• YEARReturns the year of a date.