How to Calculate Business Days
Count working days between two dates, excluding weekends.
The Formula
Weekdays onlyThe business days formula uses the mathematical relationship: Weekdays only. Each variable in the formula represents a measurable quantity that affects the final result.
What Each Variable Means
Every value in the business days formula, what it measures, and the value used in the worked example on this page:
| Variable | Type | Example value |
|---|---|---|
| Start Year | Input (you provide) | 2,026 |
| Start Month | Input (you provide) | 11 |
| Start Day | Input (you provide) | 2 |
| End Year | Input (you provide) | 2,026 |
| End Month | Input (you provide) | 11 |
| End Day | Input (you provide) | 13 |
| Weekday Holidays to Exclude | Input (you provide) | 0 |
| Total Calendar Days | Result (calculated) | — |
| Business Days | Result (calculated) | — |
| Weekend Days | Result (calculated) | — |
| Net Business Days (after holidays) | Result (calculated) | — |
Step-by-Step Method
- 1Write down the values you know: Start Year, Start Month, Start Day, End Year, End Month, End Day, Weekday Holidays to Exclude.
- 2Substitute your known values into the formula: Weekdays only.
- 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
- 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
- 5Verify your answer with the interactive Business Days Calculator — it solves the same formula instantly.
Worked Example
Take a concrete case: start year = 1,000, with the other inputs at the typical values from the variables table above. Substituting into the formula gives total calendar days = 374750, business days = 267680, weekend days = 107070, net business days (after holidays) = 267680. These numbers are solved by the same engine that powers the Business Days calculator, so you can reproduce them exactly by entering the same inputs there.
| Start Year | Total Calendar Days | Business Days | Weekend Days | Net Business Days (after holidays) |
|---|---|---|---|---|
| 1 | 739627 | 528305 | 211322 | 528305 |
| 1,000 | 374750 | 267680 | 107070 | 267680 |
| 2,000 | 9507 | 6791 | 2716 | 6791 |
| 3,000 | 355735 | 254095 | 101640 | 254095 |
| 4,000 | 720978 | 514984 | 205994 | 514984 |
| 5,000 | 1086220 | 775870 | 310350 | 775870 |
| 6,000 | 1451463 | 1036759 | 414704 | 1036759 |
| 8,000 | 2181948 | 1558534 | 623414 | 1558534 |
How each result changes as start year changes, holding the other inputs constant.
Practice Problems
1. Mon Nov 2 → Fri Nov 13, 2026: Plug in Start Year 2,026, Start Month 11, Start Day 2, End Year 2,026, End Month 11, and 2 more more inputs. What is the answer?
Answer: Entering Start Year 2,026, Start Month 11, Start Day 2, End Year 2,026, End Month 11, and 2 more more inputs gives Total Calendar Days 11, Business Days 9, Weekend Days 2, Net Business Days (after holidays) 9.
2. Given Start Year 2,533, Start Month 2, Start Day 14, End Year 2,026, End Month 2, and 2 more more inputs, what does it come out to?
Answer: The calculator returns Total Calendar Days 185,170, Business Days 132,265, Weekend Days 52,905, Net Business Days (after holidays) 132,260 for Start Year 2,533, Start Month 2, Start Day 14, End Year 2,026, End Month 2, and 2 more more inputs.
Frequently Asked Questions
What is the formula for business days?
The formula is: Weekdays only. Count working days between two dates, excluding weekends.
What values do I need to calculate business days?
You need start year, start month, start day, end year, end month, end day, weekday holidays to exclude. The calculator produces total calendar days, business days, weekend days, net business days (after holidays) from those inputs.
What is the business days when start year is 1,000?
With start year = 1,000, the result is total calendar days = 374750, business days = 267680, weekend days = 107070, net business days (after holidays) = 267680. This is worked through in full in the example on this page.
Related Topics
Use the Interactive Calculator
Skip the manual math — get instant results with our free Business Days calculator.
