All Tools

Business Days Calculator

Calculate dates excluding weekends and holidays. Perfect for project planning and business scheduling.

Date Difference

Difference

  • years:0
  • months:0
  • weeks:0
  • days:0
  • hours:0
  • minutes:0
  • seconds:0

Business Days

0

Weekdays excluding weekends


Business days calculator

Formula

Count weekdays (Monday through Friday) between two dates, excluding public holidays if specified.

businessDays=∑i=0n−1{1if weekday(datei)∈[1,5]0otherwise\text{businessDays} = \sum_{i=0}^{n-1} \begin{cases} 1 & \text{if weekday(date}_i\text{)} \in [1,5] \\ 0 & \text{otherwise} \end{cases}

Where n is the number of days in the range (exclusive of end date).

Worked example

Calculate business days from 1 January 2025 to 15 January 2025:

  1. 1 Jan 2025 is Wednesday (business day) ✓
  2. 2 Jan 2025 is Thursday (business day) ✓
  3. 3 Jan 2025 is Friday (business day) ✓
  4. 4 Jan 2025 is Saturday (weekend) ✗
  5. 5 Jan 2025 is Sunday (weekend) ✗
  6. 6 Jan 2025 is Monday (business day) ✓
  7. Continue until 15 Jan...

Result: 10 business days (excluding weekends)

How to use

  1. Enter the start date
  2. Enter the end date
  3. Optionally add public holidays to exclude
  4. Click "Calculate" to see the business days count

Weekend convention

  • Saturday = Day 6 = Not a business day
  • Sunday = Day 0 = Not a business day
  • Monday to Friday = Days 1-5 = Business days

Adding business days

To add business days to a date, skip weekends and holidays. For example, adding 5 business days to a Friday lands on the following Friday, not the following Wednesday.

Common use cases

  • Calculating project deadlines
  • Determining payment terms (net 30 business days)
  • HR and payroll calculations
  • Legal and contractual deadlines
  • Shipping and delivery estimates

FAQ

How many business days in a month? Typically 20-23, depending on the month and holidays. On average, there are about 21.7 business days per month.

Is today a business day? This tool requires a specific date range. Check your calendar or use the date difference tool with today as both dates.

What about holidays? Add them to the holiday list to exclude them from the count. Public holidays vary by country and region.

Can I calculate in weeks? No, business days are counted in days. Divide by 5 for business weeks.

Does this include lunch breaks? No, business days count full calendar days, not working hours.

Other related tools