How to use this calculator
- Enter or choose start date.
- Enter or choose end date.
- Enter or choose weekly days off.
- Enter or choose public holidays (one per line).
- Enter or choose hours per working day.
- The working days updates as you type. Use Copy result or Share to keep it.
Method
Working days = Calendar days − Weekly days off − Holidays falling on working days
- Calendar days
- every day from the start date to the end date, both included
- Weekly days off
- days matching your weekend pattern
- Holidays
- the dates you list; a holiday on a day off is not subtracted twice
Worked example
- December 2026 has 31 days and starts on a Tuesday, so it has 8 Saturdays and Sundays and 23 weekdays.
- 25 December is a Friday, so it removes one working day: 23 − 1 = 22.
- 26 December is a Saturday, already a day off, so it changes nothing.
- 22 days × 8 hours = 176 working hours.
December 2026 has 22 working days (176 hours at 8 hours a day) with a Saturday–Sunday weekend and holidays on 25 and 26 December.
What the result means
Use the count for project schedules, leave planning and pro-rata pay. If your employer moves a holiday that falls on a weekend to the next working day (a “substitute day”), add that date to the list.
Assumptions and limits
- Both the start and the end date are counted.
- Only the holidays you enter are excluded; no national calendar is built in.
- Half-day holidays and shift patterns that change week to week are not modelled.
Questions
Why are public holidays not filled in automatically?
They differ by country, state, region and sometimes employer, and some are announced each year. Entering them yourself keeps the count right for where you work.
Is this the same as Excel’s NETWORKDAYS?
Yes for a Saturday–Sunday weekend: both dates are included and listed holidays are skipped. Other weekend patterns match NETWORKDAYS.INTL.