CalcQuick · Workdays

Business Days and Workday Calculator

Choose a date calculation, weekend pattern and a federal or nationwide holiday preset. Range results show the calendar dates evaluated and the weekend and holiday exclusions. Add state, regional, municipal, employer and one-off holidays when they apply.

Reviewed and updated: September 1, 2026

Start dateEnd date

Regional holiday presetRecurring federal or nationwide dates only. Add state, local, employer and one-off holidays below.

Weekend days

Select every non-working weekday. At least one workday must remain.

Include both start and end datesCustom holidays

Workdays5

Calendar days evaluated: 5
Weekend days excluded: 0
Holidays excluded: 0

2026-08-24 → 2026-08-28

How to use this calculator

Enter your values using the units shown.
Review the result, which updates instantly.
Check the formula and assumptions before using the number for a decision.

Formula and assumptions

A workday is a calendar date that is neither a selected weekend day nor a preset or custom holiday. Range mode separates evaluated calendar dates into workdays, weekends and weekday holidays; date-shift mode moves until the requested number of eligible days is reached.

Methodology →Business Days Between Dates: A Clear Counting Guide →

Worked example

Monday 24 August through Friday 28 August 2026 contains 5 workdays with both endpoints included. Adding 5 workdays to 24 August, without counting the base date, gives Monday 31 August.

CalcQuick

Sources and scope

These references support the formula or category guidance. CalcQuick remains responsible for the calculator implementation.

NETWORKDAYS.INTL functionMicrosoft Support
WORKDAY.INTL functionMicrosoft Support
Federal holidaysU.S. Office of Personnel Management

FAQ

Frequently asked questions

Are the start and end dates included?

Both are included by default when they are workdays. Turn off the endpoint option to exclude both dates from the range count.

How do regional holiday presets work?

Choose a federal or nationwide preset, then add any state, regional, municipal, employer or one-off dates manually. A holiday on an excluded weekend is not subtracted twice.

What does the date-range breakdown show?

It shows how many calendar dates were evaluated, how many selected weekend dates were excluded and how many holidays were excluded. A holiday that falls on a selected weekend is counted only as a weekend date.

Does the base date count when I add workdays?

Not by default. Counting starts on the next eligible workday. Enable the day-one option if your rule includes a workday base date.

Can I change which days are weekends?

Yes. Select any non-working weekdays, such as Friday and Saturday. The same weekend rule is used for counting and date shifting.