Overview
This counts the working days between two dates, both included, minus holidays. It also shows the working hours and calendar days.
Enter the dates as YYYYMMDD, the number of holidays in that period, your workdays per week (5 means Monday to Friday) and hours per workday.
Worked examples
| Inputs | Result |
|---|---|
| Start Date (YYYYMMDD)20,260,223End Date (YYYYMMDD)20,260,331Holiday Count1Workdays per Week5Hours per Workday8 | Business days: 26Work hours: 208Calendar span: 37 days |
Show 2 more examples
| Start Date (YYYYMMDD)20,260,105End Date (YYYYMMDD)20,260,130Holiday Count0Workdays per Week5Hours per Workday8 | Business days: 20Work hours: 160Calendar span: 26 days |
| Start Date (YYYYMMDD)20,261,201End Date (YYYYMMDD)20,261,231Holiday Count2Workdays per Week4Hours per Workday10 | Business days: 17Work hours: 170Calendar span: 31 days |
Business days by workdays per week
With the calculator's starting values, the business days is 26. The table shows how it changes with the workdays per week.
| Workdays per Week | Business days |
|---|---|
| 3 | 16 |
| 4 | 21 |
| 5starting value | 26 |
| 6 | 31 |
| 7 | 36 |
Other inputs: Start Date: 20,260,223 YYYYMMDD · End Date: 20,260,331 YYYYMMDD · Holiday Count: 1 · Hours per Workday: 8. Change them in the calculator above for your own numbers.
How it works
Every date in the range is checked, counting a day if it falls within your workweek starting on Monday. The holidays you enter are then subtracted. Count only holidays that fall on workdays.
The formula
Practical tips
- 23 February to 31 March 2026 has 27 weekdays, so 26 business days with one holiday, or 208 hours at 8 a day.
- Both the start and end dates are counted.
- For a 4-day week, enter 4, which counts Monday to Thursday.
Frequently asked questions
Does it know public holidays?
No. Enter how many fall on workdays in your range, since they vary by country and region.
Are both dates included?
Yes. 2 to 6 March 2026, Monday to Friday, counts as 5 business days.
What about shift work?
This assumes a workweek starting on Monday. For other patterns, count manually.