How to Calculate Business Days in HubSpot
To calculate business days in HubSpot, install the Business Days Calculator app 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. The Business Days Calculator fills that gap, the same role that the NETWORKDAYS function plays in Excel.
Step by step
-
1.
Install the Business Days Calculator Authorize the Business Days Calculator 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. Use it in branches, delays, SLA logic, or write it back to a property.
Native HubSpot vs custom code vs the 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 |
| Business Days Calculator | Yes | Yes, automatic | Yes, 145 plus countries | Low, install and pick a country |
The Business Days Calculator gives you a real 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. The Business Days Calculator adds one 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 145 plus countries.
- Is it free?
- Yes. The Calculate Business Days action is free forever, with no credit card and no usage limit.
Written by Sharoze Iftikhar, RevOps consultant and creator of the Business Days Calculator.