Dates & time
Work calendar hours
Summarise eligible dates and assumed working hours by month.
A clear answer. Here’s how.
Includes both date endpoints, counts only your selected weekdays and removes your explicit excluded dates. Multiplies every eligible date by the same hours-per-day input and reports monthly totals. Maximum span 36,600 calendar days. This is a workload scenario without shifts, leave rules, time zones or country calendars.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Start date
- 2026-10-01
- End date
- 2026-10-31
- Working weekdays (1=Monday … 7=Sunday)
- 1,2,3,4,5
- Excluded dates, one YYYY-MM-DD per line
- 2026-12-25
- Hours on each eligible day
- 7.5
Example result
| Month | Eligible dates | Scenario hours |
|---|---|---|
| 2026-10 | 22 | 165 |
Inclusive endpoints. Only your working weekdays and excluded-date list are applied.