Holiday exclusions
Exclude holidays business days between dates
Exclude holidays business days between dates by combining presets and custom closures. This guide shows how totals change when you drop holidays, why presets are a starting point, and how to update the business day calculator quickly.
Published: December 28, 2025 · Updated: December 28, 2025 · By FinToolSuite Editorial
Disclaimer
- Educational purposes only; not legal or financial advice.
- Examples are illustrative and simplified.
- Results depend on your inputs and assumptions and are not guaranteed.
- Preset holiday lists can be static and may not cover regional observances.
- Read the Privacy Policy; do not share personal data.
Quick answer: exclude holidays business days between dates
- Turn on holiday exclusions and pick the correct year preset.
- Add custom holidays for regional or company closures not in the preset.
- Totals can change if holidays land on start, end, or weekend-adjusted days.
How holiday presets work
Presets load common public holidays for a chosen year. They remove those days from business day counts while leaving weekends controlled by your weekend pattern. Always match the preset year to your date range.
Why presets can be incomplete
Regional observances, provincial days, and company shutdowns may not appear in presets. Treat presets as a starting point, then add custom closures to avoid undercounting non-working days.
Worked examples
Example A: Holidays off vs on
Range spans one holiday Monday, include both.
Result: 5 business days with holidays off; 6 if holidays included.
Example B: Canada Day style period
Range covers 01 July, include both, weekend Sat–Sun.
Result: drops 1 extra day when holiday excluded.
Example C: Add custom closure
Add a company shutdown Friday; include both.
Result: drops one more day from the total.
How to add custom holidays
- Open the business day calculator.
- Turn on holiday exclusion and select a preset for the correct year.
- Add custom holiday dates for regional observances and company closures.
- Confirm the weekend pattern and inclusion mode.
- Run the business day counter and share assumptions.
Use the business day calculator to apply these steps.
Common mistakes
- Assuming all regions share the same holidays.
- Using the wrong holiday year for ranges that cross New Year.
- Forgetting company shutdown days.
- Changing inclusion mode and thinking the calculator is wrong.
- Mixing calendar days and business days in reports.
- Leaving weekend pattern at Sat–Sun when it differs regionally.
FAQ
How do I exclude holidays from business days between dates?
Enable holiday exclusion, pick a preset year, and add custom dates.
Why did my total change when I toggled holidays?
Holidays drop from the count, including if they land on start or end dates.
Are holiday presets complete?
They are illustrative. Add regional and company closures via custom holidays.
Can I mix holiday presets and custom holidays?
Yes. Use both for accurate counts.
Do holidays matter if I use calendar days?
No. Holidays only change totals in business day mode.
Is this guaranteed?
No. Results depend on your inputs and assumptions and are not guaranteed.
Is this legal or financial advice?
No. This guide is educational. Confirm with your advisor.
Calculate business days now
Pick your weekend pattern, load holidays, add custom closures, and run the business day counter.