How do I count working days between two dates?

Select a start date and end date. Enable "Exclude weekends" to skip Saturday and Sunday. Optionally select your region to also exclude public holidays. The result shows the number of working (business) days in the range.

Which holidays are included?

US holidays include all 11 federal public holidays (New Year's Day, MLK Day, Presidents' Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving, Christmas). UK holidays cover England & Wales public holidays including Easter. Canadian holidays include federal public holidays.

What if my date range goes beyond the holiday data?

Holiday data is embedded for 2024–2027. If your date range extends beyond that, the calculator still counts weekdays correctly but cannot exclude holidays outside the embedded range. A warning is shown in that case.

Does the calculator include the start and end date?

The calculator counts from the start date (inclusive) to the end date (exclusive) - the same way most date-range calculations work. For example, Jan 1 to Jan 3 counts 2 days (Jan 1 and Jan 2).

Working Days Calculator

How business days are counted

Working days (also called business days) are Monday through Friday, excluding weekends. When a public holiday falls on a Saturday, many countries observe it on Friday; when it falls on Sunday, it is observed on Monday. This calculator applies the observed-day rule for all three holiday regions.

US federal holidays (2025)

Holiday	2025 Date
New Year's Day	Jan 1
Martin Luther King Jr. Day	Jan 20
Presidents' Day	Feb 17
Memorial Day	May 26
Juneteenth	Jun 19
Independence Day	Jul 4
Labor Day	Sep 1
Columbus Day	Oct 13
Veterans Day	Nov 11
Thanksgiving Day	Nov 27
Christmas Day	Dec 25

Holiday data based on US federal calendar through 2027. For calculations beyond 2027, weekdays are counted but holidays are not excluded.

Project deadline use cases

10 business days delivery: a package shipped Monday needs 2 full calendar weeks, potentially longer if a holiday falls in the span.
5-day SLA: a support ticket opened on Wednesday must be resolved by the following Wednesday (skipping weekend), or Tuesday if Monday is a holiday.
Contract payment terms: “Net 30 business days” from an invoice dated November 20 would land in early January after accounting for Thanksgiving and Christmas.

International holiday notes

This tool uses US federal holidays. For international use, be aware of regional differences:

Canada: includes federal holidays plus provincial ones (Family Day in most provinces, Civic Holiday in Ontario/Alberta). Dates vary by province.
United Kingdom: Bank Holidays differ between England/Wales, Scotland, and Northern Ireland (e.g., Scotland observes 2 January; England does not).
For accurate international calculations, use a region-specific calendar library (e.g., python-holidays for Python).

Programmatic equivalents

Excel: =NETWORKDAYS(start_date, end_date, holidays_range) counts working days between two dates.
Python / NumPy: numpy.busday_count(‘start’, ‘end’) counts business days (Mon–Fri, no holiday awareness).
Python with holidays: import holidays; us = holidays.US(years=2025) gives a dict of holiday dates to exclude.