deepcalc
DocsNETWORKDAYS

NETWORKDAYS

View as markdown/docs/functions/networkdays.md Ask Claude about this pageOpens Claude with this page's address

Returns business days between two dates.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=NETWORKDAYS(DATE(2026,7,1), DATE(2026,7,31))
Result 23

Syntax

NETWORKDAYS(start_date, end_date, [holidays])
start_date
number required
end_date
number required
holidays
range optional

Errors

#ERROR!
=NETWORKDAYS(1,2,3,4)
#NUM!
=NETWORKDAYS(1,3000000)
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year.