Weekdays Calculator
Count weekdays between two dates using the days-not-counted pattern you choose. Add your own extra dates to exclude when needed.
Examples
A date range from 4 May 2026 to 18 May 2026 with Saturday and Sunday skipped.
Weekdays
10
Calendar days
14
Days not counted
4
Extra dates excluded
0
About 10 weekdays in this range.
Extra dates are only the dates you provide.
Was this useful?
Examples
How It Works
Formula
Variables
- Total days in the range, exclusive of the end date
- Dates counted after exclusions — the headline answer
- Dates skipped by the selected days-not-counted pattern
- User-listed extra dates skipped inside the range
The calculator walks day by day from your start date to the day before your end date and bins each date as counted, skipped by the days-not-counted pattern, or skipped because it appears in your extra-date list. A listed date is excluded only when it is inside your range and not already skipped by the chosen pattern.
Day-by-day walk under a chosen days-not-counted pattern:
- Parse the start and end dates as UTC-midnight ISO timestamps.
- Resolve the skipped weekday set from the chosen pattern: Sat-Sun, Fri-Sat, or Sun-only.
- Parse the optional extra-date list into a set of UTC-midnight timestamps.
- For each date in , count it as daysNotCounted, excludedDates, or weekdays.
- If the end date precedes the start date, negate all counts so the sign surfaces the reversed range.
Frequently Asked Questions
01Is the end date counted?
No. The calculator uses the [start, end) convention: the start date is counted and the end date is not. To include both endpoints, add one day to the end date.
02Are extra dates prefilled?
No. This calculator only uses the pattern you choose and the dates you type. Add any extra dates you want to exclude, one per line in YYYY-MM-DD form.
03Which days-not-counted pattern should I pick?
Pick the days you want the calculator to skip. Sat & Sun is the default, Fri & Sat skips those two days, and Sun only skips Sundays.
04Does it handle reverse date ranges?
Yes. If your end date is earlier than your start, the calculator returns negative counts so the reversed range is visible. Flip the inputs to read a positive count.
05How is this different from Date Difference and Hours Between?
Date Difference counts every calendar day. Hours Between handles intra-day clock-time spans. This calculator counts only the weekdays left after your chosen skipped-day pattern and any extra dates you provide.