NETWORKDAYS Excel Formula
Excel's NETWORKDAYS() function counts the working days between two dates. It includes the start and end date when they fall on weekdays, excludes Saturdays and Sundays, and can also exclude a holiday range you provide.
Basic syntax
=NETWORKDAYS(start_date, end_date, [holidays])
For example, if cell A2 contains January 5, 2026, cell B2 contains January 16, 2026, and H2:H10 contains your holiday dates, use =NETWORKDAYS(A2,B2,H2:H10). With no weekday holidays in that range, Excel returns 10 working days.
How the formula works
-
1.
Provide the date range The first two arguments can be cell references, fixed Excel dates, or formulas that return dates. Excel counts the range inclusively.
-
2.
Add a holidays range The optional third argument points to cells containing dates that should not count as working days. A holiday only reduces the result when it falls on a weekday.
-
3.
Use NETWORKDAYS.INTL for custom weekends
NETWORKDAYS.INTL()adds a weekend argument, so you can define non-standard weekends such as Friday and Saturday. Its syntax is=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]).
The limitation: holiday data is still manual
NETWORKDAYS does not know which country you operate in. You must create and maintain a holiday table for every country you need, reference the correct range in each formula, and update those dates as calendars change.
The formula also does not run inside HubSpot. If your deal, ticket, or response-time data lives in HubSpot, you either rebuild the logic with custom code or export the records to Excel before calculating SLA and cycle-time metrics.
Excel formula vs HubSpot workflow action
| Capability | Excel NETWORKDAYS | NetworkDays business days calculator for HubSpot |
|---|---|---|
| Excludes weekends | Yes | Yes |
| Public holiday data | Manual cell range | Automatic for 250 plus countries |
| Runs on HubSpot records | No, export required | Yes, inside workflows |
| Company holidays | Add dates to the range manually | Add them to the app calendar |
Skip the spreadsheet: get this in HubSpot instead
NetworkDays performs the same core business days calculator function as a HubSpot workflow action. Map two date properties, choose a country, and use the returned business-day count in branches, SLA logic, property updates, and reporting.
Public holiday data for 250 plus countries is maintained automatically, so there is no Excel holidays range to rebuild. You can also add company holidays for dates specific to your organization.
Install the app freeCommon questions
- What does NETWORKDAYS mean in Excel?
- NETWORKDAYS is an Excel function that returns the number of working days between a start date and an end date. By default, working days are Monday through Friday.
- Does NETWORKDAYS count the start and end date?
- Yes. NETWORKDAYS counts both dates when they are working days. If either date falls on a weekend or appears in the holidays range, that date is excluded.
- How do I exclude holidays in NETWORKDAYS?
- Put the holiday dates in a cell range, then pass that range as the third argument. For example,
=NETWORKDAYS(A2,B2,H2:H10)excludes weekday dates listed in H2:H10. - Is there a NETWORKDAYS function in HubSpot?
- No. HubSpot does not have a native NETWORKDAYS formula. NetworkDays adds the business days calculation as a workflow action, including automatic public holiday data for the country you select.
Written by Sharoze Iftikhar, RevOps consultant and creator of the NetworkDays business days calculator.