How to Calculate Working Days Between Dates

Enter the two dates in YYYY-MM-DD format, choose the weekend rule, and add valid holiday dates when needed. The calculator returns a working-day count for the inclusive period you specify, subject to those choices and inputs.

When to use a working-day count

A working-day count is useful for planning a delivery period, reviewing a service window, or estimating time available for a project. This calculator works with two dates and can remove weekends and holiday dates that you enter. The range is inclusive, so the first and last dates belong to the period considered. That rule helps you compare the displayed count with a schedule whose boundaries are clearly defined.

You can tailor the count to a Monday-through-Friday workweek or allow weekend dates to participate. Holiday handling is based on the dates supplied for this calculation, which lets you account for selected dates instead of relying on an assumed calendar. Before starting, gather the period boundaries and decide whether specific holidays should be left out. A short, deliberate input list makes the resulting count easier to review and explain to someone else.

The tool accepts calendar dates in YYYY-MM-DD format. For example, April 1, 2025 is entered as 2025-04-01, with leading zeroes where the format requires them.

Set the period and exclusions

1. Enter the starting date and ending date in YYYY-MM-DD format. Use valid calendar dates, such as 2025-04-01 and 2025-04-30, rather than a month/day/year variant. The two fields define the period to be counted.

2. Check the weekend setting before calculating. Weekend exclusion is enabled by default; with it enabled, Monday through Friday are treated as working days and Saturday and Sunday are left out. Keep that setting for a conventional weekday schedule.

3. Add selected holidays when they should not contribute to the count. Enter the dates as a comma-separated list, using YYYY-MM-DD for each entry. A holiday date that cannot be parsed in that format is ignored, so review the list instead of assuming that every typed item changed the result.

4. Disable weekend exclusion when Saturday and Sunday should be counted. With that option off, dates across the range can count as working days, while valid holiday dates supplied in the list remain excluded.

5. Run the calculation and read the working-day count. If you omit the start date, the default is 2024-01-01; if you omit the end date, the default is 2024-12-31. If the start date is later than the end date, the calculation processes the dates in chronological order. Invalid date text produces an error indication rather than a calculated range.

Understand the number shown

The displayed number is the working-day count produced by the dates and settings you supplied. With weekend exclusion enabled, the count follows Monday-through-Friday dates and removes valid holiday dates that fall within the period. Turning that setting off permits weekend dates to enter the count, but it does not make a valid supplied holiday count as a working day.

Remember that both boundaries are part of the inclusive range. A date on the first day or final day can therefore affect the total when it meets the selected counting rules. The chronological-order behavior also means that reversing the two dates does not describe a negative period; the dates are processed from the earlier one to the later one.

The holiday list is not a substitute for a regional or public-holiday calendar. Only valid dates entered as holiday input affect the calculation. If the displayed number differs from your schedule, compare the boundary dates, weekend choice, and each holiday entry before changing the dates. An invalid date field requires correction because it produces an error indication instead of a count.

Worked example

A project manager enters 2025-07-01 as the start, 2025-07-10 as the end, and 2025-07-04 as the holiday to check the available workdays.

Enter the two dates, add the holiday as a comma-separated entry, leave weekend exclusion enabled, and run the calculation. Then compare the displayed count with the period and exclusions used in this scenario. The action tests weekday counting while removing the supplied holiday.

For this period, the result is 7 working days: July 1 through July 10, 2025 spans eight weekdays once the July 4 holiday is removed from the count.

Limitations

• Holiday treatment depends on valid dates entered in the holiday list; the calculation does not add a regional calendar automatically.

Common errors

• Entering a date such as 04/01/2025 instead of 2025-04-01 can produce an error indication; replace it with the required format and verify the calendar date.

FAQ

Does the calculator exclude weekends?

When weekend exclusion is enabled, the count uses Monday through Friday and leaves Saturday and Sunday out. Disable that setting when weekend dates should participate in the calculation; valid supplied holidays remain excluded.

Are public holidays included automatically?

Only holiday dates entered in a valid YYYY-MM-DD format affect the result. Entries that cannot be parsed in that format are ignored, so regional dates need to be entered when they apply to your schedule.

Are the start and end dates included?

Both boundary dates belong to the inclusive period used for counting. When the start is later than the end, the dates are processed in chronological order rather than producing a reversed-period count.