NETWORKDAYS Google Sheet Formula

Generate Google Sheet NETWORKDAYS Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

NETWORKDAYS Formula Syntax

=NETWORKDAYS("2023-01-01", "2023-01-31")

Example Use Case

Calculating the number of working days between two dates

Understanding the NETWORKDAYS Formula

The NETWORKDAYS function in Excel calculates the number of working days between two dates, excluding weekends (Saturday and Sunday) and optionally specified holidays. It's a business day calculator for project planning—like estimating delivery dates or calculating work hours.

NETWORKDAYS("2023-01-01", "2023-01-31") returns 22, counting Monday through Friday in January 2023. It takes start_date, end_date, and optional holidays arguments, providing an accurate count of business days—perfect for realistic project timelines or labor calculations.

Why Use NETWORKDAYS?

NETWORKDAYS calculates business spans—think project timelines or payroll periods. Its weekend and holiday exclusion makes it valuable for business planning, resource allocation, or anywhere accurate work day counts matter.

Example with Sample Data

Date Range, [Holidays]	Formula	Result
1/1/2023 to 1/31/2023	=NETWORKDAYS("1/1/2023", "1/31/2023")	22
1/1/2023 to 1/31/2023, MLK Day	=NETWORKDAYS("1/1/2023", "1/31/2023", {"1/16/2023"})	21
TODAY() to project deadline	=NETWORKDAYS(TODAY(), "6/30/2023")	[Working days until deadline]

NETWORKDAYS counts business days: 22 workdays in January 2023, 21 when excluding MLK Day. It's a working day calculator.