Formulas > =NETWORKDAYS()
How to Use NETWORKDAYS() in Google Sheets
Description
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.
Hints (2)
-
Make sure to reference the correct cells for start and end dates.
-
Remember that NETWORKDAYS excludes weekends.
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
More related tutorials
Transcript-matched member videos for NETWORKDAYS(). Click through to watch.
REGEXMATCH Formula Generator for Google Sheets
Write Apps Script to Create a New Google Sheets Formula
One Weird Google Sheet Formula for Bulk Publishing With AI
Create a Trello Board with Transpose Formula in Google Sheets
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