Formulas > =NETWORKDAYS.INTL()
How to Use NETWORKDAYS.INTL() in Google Sheets
Description
How To Actually Use NETWORKDAYS.INTL() in Sheets
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Try NETWORKDAYS.INTL yourself
Use the NETWORKDAYS.INTL formula to calculate the number of working days between the dates in cells A1 and A2, excluding weekends. Place your answer in cell B1.
Hints (3)
-
Remember to specify the weekend type in the formula.
-
The weekend type '1' means Saturday and Sunday.
-
Ensure your dates in A1 and A2 are valid.
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.INTL() formula:
Generate a NETWORKDAYS.INTL() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NETWORKDAYS.INTL(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NETWORKDAYS.INTL() formula