How to Calculate Business Days in HubSpot
To calculate business days in HubSpot, install NetworkDays and add its Calculate Business Days action to a workflow. Set the start date and end date to your HubSpot date properties, choose your country, and the action returns the number of working days between them, excluding weekends and public holidays.
HubSpot has no native function to count business days between two dates. Its workflow delays count calendar days, and date math in calculated properties does not exclude weekends or localized public holidays. NetworkDays fills that business days calculator gap, the same role that the NETWORKDAYS function plays in Excel.
Step by step
-
1.
Install NetworkDays Authorize the NetworkDays app in your HubSpot portal through direct OAuth. The Calculate Business Days action then appears in the workflow editor.
-
2.
Set your country Open the app home page in HubSpot and choose your country. The app loads that country public holiday calendar automatically.
-
3.
Add the Calculate Business Days action In any workflow, add the Calculate Business Days action from the action list.
-
4.
Map your date properties Set the Start Date and End Date inputs to the HubSpot date or datetime properties you want to compare.
-
5.
Use the result The action outputs the number of working days, excluding weekends and holidays - available immediately in that same workflow, for branches or delays.
-
6.
Save it to a property (if you want to report on it) The calculation action doesn't save its output anywhere by itself. Add HubSpot's native "Set property value" action right after it, choose the property to write to, and set its value to the calculation action's output using the token picker. Now it's a real property - usable in reports, list filters, or shown on the record. For a ticket-based example, see reporting SLAs in business days. Full walkthrough: Workflow Actions docs.
Native HubSpot vs custom code vs the NetworkDays business days calculator
| Approach | Counts business days as a number | Excludes weekends | Localized public holidays | Effort to set up |
|---|---|---|---|---|
| HubSpot native (workflow delay) | No, it only waits | Partial | No | Low |
| Custom coded action (your own JS) | Yes | Yes, if you code it | Only if you maintain a holiday list | High, ongoing maintenance |
| NetworkDays | Yes | Yes, automatic | Yes, 250 plus countries | Low, install and pick a country |
NetworkDays gives you a real business-day number you can branch, delay, or report on, without writing or maintaining code.
Common questions
- Does HubSpot have a NETWORKDAYS function?
- No. HubSpot has no built-in function equivalent to Excel NETWORKDAYS. NetworkDays adds a business days calculator as a workflow action, returning the count of business days between two dates.
- Can I calculate business days between two date properties?
- Yes. Map the Start Date and End Date inputs to any two HubSpot date or datetime properties. The action returns the working days between them as a number.
- Does it exclude public holidays?
- Yes. Pick your country and the action excludes that country public holidays as well as weekends. Coverage spans 250 plus countries.
- Is it free?
- Yes. The Calculate Business Days action is free to use, with no credit card required. The free tier includes 3,000 calculations a month, and Pro removes that cap.
Written by Sharoze Iftikhar, RevOps consultant and creator of the NetworkDays business days calculator.