Work Days Calculator
Count the working days between two dates, excluding weekends and holidays.
Formula and sources updated · Data sources · 1View algorithm, constants and default inputs (JSON)
About this calculator
Count weekdays between two dates. The start date is included; choose whether to include the end date. Enter the number of public holidays that fall on weekdays inside the range. This uses a Monday-to-Friday schedule and does not know local holiday calendars.
Worked example
calculated with the default values below
Start date 2026-10-31 · End date 2027-01-31 · Public holidays to exclude 4 days · Count the end date No · Hours per working day 8 hours Working days 61 days · Calendar days 92 days · Weekend and holiday days 31 days · Working hours 488 hours · Working weeks 12.20 weeks · End date used 2027-01-31 · Average working days per calendar week 4.64 days
Method and assumptions
N = counted weekdays − min(holiday count, counted weekdays); hours = N×hours/day; weeks = N/5 The loop counts weekdays (Monday–Friday) between the dates; the start is included and the end is included only when selected. Enter the number of public holidays that fall on counted weekdays; the value is capped at the weekday count. Hours = working days×hours/day; weeks = working days÷5; weekly average is undefined for a zero-day interval. Count weekdays between two dates. The start date is included; choose whether to include the end date. Enter the number of public holidays that fall on weekdays inside the range. This uses a Monday-to-Friday schedule and does not know local holiday calendars. The references explain definitions and methods; any extra preset must be checked against the assumptions on this page.
Data sources
The references explain definitions and methods; any extra preset must be checked against the assumptions on this page.
Disclaimer
These calculators give general date results. Public holidays, working-day conventions and time-zone rules are set locally and change, so confirm against the official calendar for anything legally or contractually binding.
Implementation source
This record describes the implementation used by this page. It is not independent validation. External references, when available, support only the stated formula or definition; estimates and custom rules retain their own assumptions.
Formula and variables
N = counted weekdays − min(holiday count, counted weekdays); hours = N×hours/day; weeks = N/5
- span
- Days between the dates
- workdays
- Allowed weekdays
- holidays
- Holidays to subtract
- e
- End-date flag (0 or 1)
- wd
- Working days
- hours
- Hours per work day
The loop counts weekdays (Monday–Friday) between the dates; the start is included and the end is included only when selected. Enter the number of public holidays that fall on counted weekdays; the value is capped at the weekday count. Hours = working days×hours/day; weeks = working days÷5; weekly average is undefined for a zero-day interval.
Frequently asked questions
How should I enter public holidays?
Enter only holidays that fall on weekdays counted in the selected date range. The calculator does not receive a holiday calendar or dates, so it subtracts the count you provide (up to the weekday total). It uses Monday–Friday and does not know local work schedules.
Which inputs and limits apply to Work Days Calculator?
Use the units shown beside each field. These are form limits, not recommended settings. Public holidays to exclude: 0–100 days; Hours per working day: 0–24 hours N = counted weekdays − min(holiday count, counted weekdays); hours = N×hours/day; weeks = N/5 The loop counts weekdays (Monday–Friday) between the dates; the start is included and the end is included only when selected. Enter the number of public holidays that fall on counted weekdays; the value is capped at the weekday count. Hours = working days×hours/day; weeks = working days÷5; weekly average is undefined for a zero-day interval. Count weekdays between two dates. The start date is included; choose whether to include the end date. Enter the number of public holidays that fall on weekdays inside the range. This uses a Monday-to-Friday schedule and does not know local holiday calendars. The references explain definitions and methods; any extra preset must be checked against the assumptions on this page.
What is a complete worked example for Start date = 2026-10-12; End date = 2027-01-12?
Inputs: Start date = 2026-10-12; End date = 2027-01-12; Public holidays to exclude = 4 days; Count the end date = No; Hours per working day = 8 hours. Calculation: N = counted weekdays − min(holiday count, counted weekdays); hours = N×hours/day; weeks = N/5. Results: Working days = 62 days; Calendar days = 92 days; Weekend and holiday days = 30 days; Working hours = 496 hours; Working weeks = 12.40 weeks; End date used = 2027-01-12; Average working days per calendar week = 4.72 days. Reference date: 2026-10-12 (UTC).