Business Days Calculator
The Business Days Calculator counts the number of working days (Monday-Friday) between two dates. It excludes weekends.
Business Days Calculator
The first date.
The second date.
What the result means
Business days are Monday through Friday. The count includes both the start and end dates. Weekends are excluded.
How to use this calculator
- 1Enter the start date.
- 2Enter the end date.
- 3Press Calculate to see the number of business days.
The formula
The calculation uses a standard, verifiable formula. Here it is in its simplest form.
Business Days = Count of Mon-Fri between start and end (inclusive)
What each variable means
| Symbol | Name | Description |
|---|---|---|
| Start | Start date | The first date. |
| End | End date | The second date. |
Step-by-step example
Example: Jan 1 (Mon) to Jan 5 (Fri), 2024
Start date:Jan 1, 2024End date:Jan 5, 2024
- 1Jan 1 (Mon) - business day
- 2Jan 2 (Tue) - business day
- 3Jan 3 (Wed) - business day
- 4Jan 4 (Thu) - business day
- 5Jan 5 (Fri) - business day
- 6Total = 5 business days
Result
5 business days
What changes the result
- Weekends (Sat, Sun) are excluded.
- Public holidays are not excluded.
- Both start and end dates are included.
Edge cases to be aware of
Unusual situations handled correctly
- Same date on a weekday = 1 business day.
- Same date on a weekend = 0 business days.
- A full week = 5 business days.
Common mistakes
Avoid these errors
- Forgetting that public holidays are not excluded.
- Not including both start and end dates.
Assumptions
- Business days are Monday through Friday.
- No public holidays are excluded.
Limitations
- Does not account for public holidays.
- Different countries have different holidays.
Frequently asked questions
Are public holidays excluded?+
No. This calculator only excludes weekends. To account for public holidays, you would need to subtract them manually based on your country's holiday calendar.