How to Use NETWORKDAYS() in Google Sheets

Description

Returns the number of net working days between two provided days.

How To Actually Use NETWORKDAYS() in Sheets

NETWORKDAYS(start_date, end_date, [holidays])

Try NETWORKDAYS yourself

Use the NETWORKDAYS formula to calculate the number of working days between the dates in cells A1 and B1. The result should be displayed in cell C1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the NETWORKDAYS() formula:

Generate a NETWORKDAYS() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses NETWORKDAYS(). 2 free AI generations, no signup. Members get unlimited use.

Generate a NETWORKDAYS() formula