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 calculated properties now offer a beta option on Time between to skip Saturdays and Sundays in the account time zone, available in Professional and Enterprise hubs. It does not exclude public or company holidays, and workflow delays wait calendar days. NetworkDays fills the holiday-aware calculation gap, the same role that the NETWORKDAYS function with its holidays argument 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 Time between (calculated property) | Yes, weekdays only | Yes (account time zone) | No | Low |
| HubSpot native (workflow delay) | No, it only waits | No, waits calendar days | 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 |
HubSpot Time between offers weekend exclusion in beta for Professional and Enterprise hubs. NetworkDays adds public holiday calendars to a business-day number you can use in workflow branches, delays, or reports, without writing or maintaining code.
Common questions
- Does HubSpot have a NETWORKDAYS function?
- HubSpot Time between can skip weekends, but has no holiday argument equivalent to Excel NETWORKDAYS. NetworkDays adds a business days calculator as a workflow action, returning the count of business days between two dates while excluding weekends and public holidays.
- 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.