Days Off Calculator
Calculate working days, weekends, and days off between two dates. Supports custom schedules, shift patterns, and holiday exclusions.
About
Payroll errors from miscounted working days cost businesses an average of 1.2% of total payroll annually. This calculator determines the exact count of working days (W), days off (D), and total calendar days (T) between any two dates. It accounts for standard 5/2 schedules, rotating shift patterns (2/2, 3/3), and custom weekday configurations. Public holidays are excluded from working day counts when specified.
The tool handles edge cases including leap years, month boundaries, and schedule phase alignment for shift workers. For employment contracts, vacation accrual, or project planning, incorrect day counts propagate into overtime miscalculations, compliance violations, and budget overruns. The formula isolates each calendar day, applies the work pattern mask, then subtracts holiday intersections to yield precise figures suitable for HR systems and financial planning.
Formulas
The total calendar days T between start date d1 and end date d2 (inclusive):
Working days W are calculated by iterating each day i in the range and applying the work pattern function P(i) which returns 1 if the day is a scheduled work day and 0 otherwise. The holiday indicator function H(i) returns 1 if day i is a public holiday:
Days off D represent all non-working days including weekends and holidays:
For rotating shift schedules (2/2, 3/3), the pattern function uses modular arithmetic where c is the cycle length and w is work days per cycle:
Where phase is the schedule offset from the reference start date, allowing alignment with actual shift rotations.
Reference Data
| Work Schedule | Work Days/Week | Days Off/Week | Annual Work Days | Annual Days Off | Common Industries |
|---|---|---|---|---|---|
| Standard 5/2 | 5 | 2 | 260 | 105 | Office, Corporate, Government |
| Extended 6/1 | 6 | 1 | 312 | 53 | Retail, Service, Small Business |
| Shift 2/2 | 3.5 (avg) | 3.5 (avg) | 182 | 183 | Security, Manufacturing |
| Shift 3/3 | 3.5 (avg) | 3.5 (avg) | 182 | 183 | Healthcare, Emergency Services |
| Shift 1/3 | 1.75 (avg) | 5.25 (avg) | 91 | 274 | Firefighters (24h shifts) |
| Part-time 3/4 | 3 | 4 | 156 | 209 | Part-time Employment |
| Continental (2-2-3) | 3.5 (avg) | 3.5 (avg) | 182 | 183 | Police, Utilities |
| Panama (2-2-3) | 3.5 (avg) | 3.5 (avg) | 182 | 183 | Mining, Oil & Gas |
| DuPont (4-week cycle) | 3.5 (avg) | 3.5 (avg) | 182 | 183 | Chemical Plants |
| 4/3 Compressed | 4 | 3 | 208 | 157 | Tech Companies, Remote Work |
| 9/80 Bi-weekly | 4.5 (avg) | 2.5 (avg) | 234 | 131 | Engineering, Aerospace |
| European Standard | 5 | 2 | 220 - 230 | 135 - 145 | EU Countries (more holidays) |