Is 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.

Are 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.

Which 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.

Does 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.

How 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.

DATDate & Time

Weekdays Calculator

Count weekdays between two dates using the days-not-counted pattern you choose. Add your own extra dates to exclude when needed.

Days not counted

Start date

End date

Extra dates to exclude

Examples

Enter values above to see results

How It Works

Formula

\text{weekdays} + \text{daysNotCounted} + \text{excludedDates} = \text{calendarDays}

Where

$\text{calendarDays}$: Total days in the range, exclusive of the end date
$\text{weekdays}$: Dates counted after exclusions — the headline answer
$\text{daysNotCounted}$: Dates skipped by the selected days-not-counted pattern
$\text{excludedDates}$: 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 $[\text{start}, \text{end})$ , 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

Related Calculators

Date Difference

Exact time span between any two dates.

Hours Between Calculator

Hours and minutes between two times.

Age Calculator

Exact age from birth date to today.

Year Progress Calculator

How much of the year has gone by today.

Weekdays Calculator

How It Works

Frequently Asked Questions

Related Calculators

All calculators

Ready to Calculate?