Working Days Calculator
Calculate net working days excluding weekends, public holidays, shift hours, and total calendar days between any two dates step-by-step.
Working Days Engine
Enter start date, end date, weekend schedule, and public holidays.
Working Days Output Summary
Quick Summary
Our working days calculator excluding weekends tool calculates net active working days between start and end dates, excluding weekend days and public holidays.
How It Works: Working Days Filtering
Working days calculation excludes non-operating calendar days:
1. **Calendar Day Span:** Iterates through every date from $\text{Start Date}$ to $\text{End Date}$.
2. **Weekend Exclusion:** Filters out non-working weekend days based on your configured work week.
3. **Public Holiday Deduction:** $\text{Net Working Days} = \text{Gross Work Days} - H_{\text{holidays}}$.
4. **Shift Hours Total:** $\text{Total Shift Hours} = \text{Net Working Days} \times \text{Hours/Shift}$.
Formula Explanation
Your net working days and total shift hours are calculated using the following equations:
Step-by-Step Worked Example
Here is a detailed 5-step breakdown for calculating working days between June 1, 2026 and June 30, 2026 (Sat/Sun weekends, 1 public holiday):
- Step 1 (Count Calendar Days): June 1 to June 30 $= \mathbf{30 \text{ calendar days}}$.
- Step 2 (Identify Weekend Days): June 2026 contains 4 Saturdays and 4 Sundays $= \mathbf{8 \text{ weekend days}}$.
- Step 3 (Calculate Gross Work Days): $30 - 8 = \mathbf{22 \text{ gross work days}}$.
- Step 4 (Subtract Public Holidays): $22 - 1 = \mathbf{21 \text{ net working days}}$.
- Step 5 (Compute Shift Hours): $21 \times 8 = \mathbf{168 \text{ total shift hours}}$, delivering **Working Days = 21 Days, Hours = 168 Hours**!
Calculation Examples: Real-World Scenario Comparison
Compare working days across different shift length configurations:
| Date Range | Weekend Schedule | Calendar Days | Net Working Days (1 Holiday) | Shift Hours |
|---|---|---|---|---|
| June 1, 2026 to June 30, 2026 | Sat & Sun (Standard 8h) | 30 days | 21 days | 168 hrs |
| June 1, 2026 to June 30, 2026 | Sat & Sun (10h Shift) | 30 days | 21 days | 210 hrs |
| June 1, 2026 to June 30, 2026 | Sun Only (6-Day Week) | 30 days | 25 days | 200 hrs |
| Jan 1, 2026 to Dec 31, 2026 | Sat & Sun | 365 days | 251 days (10 holidays) | 2,008 hrs |
Benefits of Using the Working Days Calculator
Utilizing working days calculations provides key workforce scheduling benefits:
- Custom Shift Hours Support: Compute shift hours for 4h, 8h, 10h, or 12h shifts.
- Flexible Weekend Schedules: Switch between 5-day (Sat/Sun), 6-day (Sun only), or 7-day work weeks.
- Deducts Custom Public Holidays: Subtract public holidays or plant shutdown days.
- Ideal for HR & Workforce Planning: Calculate payroll working days and project capacity.
Frequently Asked Questions (FAQ)
What is a working days calculator?
A working days calculator computes net active work days between two dates, excluding weekends and public holidays.
How many working days are in a typical month?
A typical month contains 20 to 22 working days.
How many working hours are in a 21-day work month at 8 hours per day?
There are 168 working hours in 21 working days ($21 \times 8 = 168$).
Can I calculate working days for part-time shift hours?
Yes. You can customize the shift hours per day (e.g. 4, 6, or 7.5 hours) to compute total shift hours.
How many working days are in a standard year?
A standard year contains ~250 to 252 working days after subtracting weekends and ~10 public holidays.
Does the calculator include the start date?
Yes. Both start date and end date are evaluated for working day status.
Can I calculate working days for a 6-day work week?
Yes. Select "Sunday Only" in the Weekend Schedule dropdown.
How are public holidays subtracted?
Enter the number of public holidays falling on working days in the Public Holidays field.
Can I use this tool for project sprint planning?
Yes. It is ideal for determining team working day capacity across project iterations.
Is this working days calculator free?
Yes. TibCal's Working Days Calculator is 100% free with no registration required.