Connect via MCP →

Enter Calculation

Formula

Advertisement

Results

Working Days
23
business days (Mon–Fri, inclusive)
Total calendar days 31
Weekend days 8

What Is the Working Days Calculator?

This tool counts the number of working days (also called business days) between two dates. Working days are Monday through Friday — weekends (Saturday and Sunday) are excluded. The count is inclusive, meaning both the start date and the end date are counted if they fall on a weekday. This is a universal tool and does not account for public holidays, which vary by country.

Calendar month grid with weekdays in blue and weekend columns shaded gray, start and end days marked
Working days count only the weekday cells (blue) between the start and end dates, skipping weekends (gray).

How to Use It

Pick a start date and an end date, then read off the working days result. The secondary table also shows the total calendar days and how many of those fell on weekends, so you can see exactly how the number was derived.

The Formula Explained

First we compute the total inclusive calendar days. Every complete 7-day week contains exactly 2 weekend days, so we multiply the number of full weeks by 2. The leftover "remainder" days (0–6) are then inspected one by one starting from the start day's weekday, and any that land on Saturday or Sunday are subtracted as well:

$$\text{business\_days} = \text{total\_days} - (\text{full\_weeks} \times 2) - \text{weekend\_days\_in\_remainder}$$

Horizontal timeline of day squares grouped into full weeks of five weekdays plus two weekend days and a remainder
The formula subtracts two weekend days per full week, then handles leftover days in the remainder.

Worked Example

From Monday 1 Jan 2024 to Wednesday 31 Jan 2024 there are 31 total days. That is 4 full weeks (8 weekend days) plus a 3-day remainder starting on Monday — none of those 3 days are weekends. So business days $$= 31 - 8 - 0 = 23$$ working days.

FAQ

Are holidays excluded? No. Only Saturdays and Sundays are removed. Subtract any public holidays manually.

Is the end date counted? Yes, the calculation is inclusive of both the start and end dates.

What if I enter the dates backwards? The calculator automatically swaps them so the result is always non-negative.

Last updated: