To calculate business days between two dates, count only the weekdays (Monday through Friday) and exclude weekends and any holidays. A free online Business Days Calculator does this instantly: enter your start and end dates, and it returns the number of working days, total days, and weekend days—all without pressing a button. You can also paste a list of holidays to subtract them from the count, making it perfect for project timelines, payroll periods, or leave planning.
If you’ve ever tried counting weekdays manually, you know it’s easy to lose track—especially when holidays fall mid-week or the period spans months. Spreadsheets like Excel offer the NETWORKDAYS function, but it still requires setup and holiday lists. A dedicated online calculator removes that friction: it defaults to today’s date, updates results live, and handles holidays in one step. Whether you’re scheduling a project, calculating payroll days, or planning leave, the tool gives you the exact number of workdays in seconds.

What Counts as a Business Day?
A business day is any weekday—Monday, Tuesday, Wednesday, Thursday, or Friday—that is not a public holiday. Weekends (Saturday and Sunday) are always excluded. Some industries or countries may define business days differently (e.g., excluding Fridays in some Middle Eastern countries), but the standard definition used by most calculators is Monday through Friday.
For example, if you’re calculating business days between Monday, June 2 and Friday, June 6, the count is 5 business days. If a public holiday falls on Wednesday, June 4, the count drops to 4. The Business Days Calculator lets you subtract holidays by pasting a comma-separated list of dates in YYYY-MM-DD format, so you don’t have to adjust the count manually.
When You Need to Calculate Business Days
Calculating business days is essential in many real-world scenarios:
- Project planning: Estimate how many workdays a task will take, excluding weekends and holidays.
- Payroll and leave: Calculate how many working days an employee has taken off or how many days remain in a pay period.
- Contract deadlines: Determine the exact number of business days until a contract expires or a deliverable is due.
- Shipping and logistics: Estimate delivery times based on business days, not calendar days.
- Financial reporting: Calculate accounts payable or receivable days to assess cash flow.
For example, if a contract states that payment is due within 15 business days of invoice date, you can use the calculator to find the exact due date, skipping weekends and holidays. Similarly, if you’re planning a 10-day project starting on a Monday, the calculator will show you the end date, accounting for weekends.
How to Calculate Business Days with the Online Tool
- Open the Business Days Calculator in your browser. The start date defaults to today—change it to your desired start date.
- Pick your end date. The calculator updates instantly, showing:
- Business days (weekdays only)
- Total days (calendar days)
- Weekend days (Saturday and Sunday)
- Optional: To exclude holidays, paste a comma-separated list of dates in
YYYY-MM-DDformat (e.g.,2026-12-25, 2026-01-01). The business-day count will adjust automatically. - Copy or screenshot the results for your records. No sign-up or download is required.
Business Days vs. Calendar Days: Key Differences
| Metric | Definition | Example (June 1–June 15, 2026) | Use Case |
|---|---|---|---|
| Business days | Weekdays (Mon–Fri), excluding holidays | 11 business days (assuming no holidays) | Project timelines, payroll, contract deadlines |
| Calendar days | All days, including weekends and holidays | 15 calendar days | Shipping estimates, event planning |
| Weekend days | Saturdays and Sundays | 4 weekend days (June 6–7, 13–14) | Leave planning, shift scheduling |
For example, if you’re estimating how long a 10-business-day project will take, the calculator will show you the end date, accounting for weekends. If the project starts on a Monday, it will end 12 calendar days later (skipping the two weekends). If you used calendar days instead, the project would appear shorter, leading to missed deadlines.
How to Calculate Business Days in Excel
If you prefer using Excel, the NETWORKDAYS function calculates business days between two dates, excluding weekends and optional holidays. Here’s how:
- Open Excel and enter your start date in cell
A1(e.g.,6/1/2026). - Enter your end date in cell
A2(e.g.,6/15/2026). - In a new cell, type
=NETWORKDAYS(A1, A2)and press Enter. This returns the number of business days (11 in this example). - Optional: To exclude holidays, list them in a range (e.g.,
B1:B3for12/25/2026,1/1/2027,7/4/2027), then use=NETWORKDAYS(A1, A2, B1:B3).
While Excel is powerful, it requires manual setup and holiday lists. The Business Days Calculator skips this step entirely—just pick your dates, and the results appear instantly. For quick, one-off calculations, the online tool is faster and more intuitive.
Common Mistakes When Counting Business Days
Even with a calculator, it’s easy to make errors when calculating business days. Here are the most common pitfalls and how to avoid them:
- Including weekends: Always double-check that the calculator is set to exclude weekends. Some tools default to calendar days, so verify the settings.
- Ignoring holidays: If your industry or country observes specific holidays, add them to the calculator’s holiday list. For example, in the U.S., July 4th and December 25th are public holidays that should be excluded.
- Counting the start date as Day 1: Some calculators include the start date in the count, while others don’t. The Business Days Calculator includes the start date by default—adjust your dates if you need to exclude it.
- Using calendar days for business deadlines: If a contract specifies "10 business days," don’t assume it means 10 calendar days. Use the calculator to find the exact end date.
- Forgetting time zones: If your dates span time zones, ensure both dates are in the same time zone to avoid off-by-one errors. The calculator uses your local time zone by default.
For example, if you’re calculating business days between June 1 and June 10, the count is 8 business days (skipping June 6–7). If you mistakenly include the weekend, you’d get 10 days, leading to incorrect deadlines or payroll calculations.
How the Calculator Handles Edge Cases
The Business Days Calculator is designed to handle tricky scenarios that manual counting often misses:
- Same-day start and end: If the start and end dates are the same, the calculator returns 1 business day (if it’s a weekday) or 0 (if it’s a weekend).
- End date before start date: The calculator returns a negative count, which can be useful for counting backward (e.g., "How many business days ago was this date?").
- Holidays on weekends: If a holiday falls on a Saturday or Sunday, the calculator ignores it—only weekdays are subtracted from the count.
- Long date ranges: The calculator handles ranges spanning years or decades without slowing down, making it ideal for long-term projects or historical analysis.
- Leap years: The calculator accounts for February 29 in leap years, ensuring accurate counts even for date ranges that include leap days.
For example, if you’re calculating business days between December 24, 2026 (Thursday) and January 4, 2027 (Monday), the count is 7 business days. The calculator skips December 25–26 (holidays) and January 2–3 (weekend), giving you the correct result instantly.
Alternatives to the Business Days Calculator
While the Business Days Calculator is the fastest way to count weekdays, other tools can help in specific situations:
| Tool | Best For | Pros | Cons |
|---|---|---|---|
| Business Days Calculator | Quick, one-off calculations | Instant results, no setup, handles holidays | Requires internet access |
Excel NETWORKDAYS |
Repeated calculations with custom holiday lists | Works offline, integrates with spreadsheets | Manual setup, requires Excel knowledge |
| Date Difference Calculator | Counting calendar days, weeks, or months | Shows total days, weeks, and months | Doesn’t exclude weekends or holidays |
Python pandas.bdate_range |
Automating business-day calculations in code | Programmable, handles large datasets | Requires coding knowledge, not user-friendly |
For most users, the Business Days Calculator is the best choice—it’s free, requires no setup, and updates results instantly. If you need to calculate business days frequently in spreadsheets, Excel’s NETWORKDAYS function is a good alternative. For developers, Python’s pandas library offers programmatic control over business-day calculations.
How to Use Business Days in Project Planning
Project managers rely on business days to estimate timelines, allocate resources, and set deadlines. Here’s how to use the calculator for project planning:
- Estimate task duration: If a task takes 5 business days, use the calculator to find the end date, accounting for weekends and holidays. For example, a task starting on Monday, June 1 will end on Monday, June 8 (skipping the weekend).
- Set milestones: Break your project into phases and assign business-day durations to each. Use the calculator to ensure milestones align with your overall timeline.
- Calculate buffer time: Add extra business days to account for delays. For example, if a task takes 10 business days, add 2–3 buffer days to handle unexpected issues.
- Track progress: Compare the actual business days taken to complete a task against the estimated duration. If a task took longer than expected, adjust future estimates accordingly.
- Communicate deadlines: Use the calculator to convert business-day deadlines into calendar dates for stakeholders. For example, "Payment is due in 15 business days" can be translated to a specific date, skipping weekends and holidays.
For example, if you’re planning a 20-business-day project starting on June 1, the calculator will show the end date as June 29 (skipping weekends and any holidays you’ve added). This helps you set realistic deadlines and avoid overpromising.
How to Calculate Business Days for Payroll
Payroll departments use business days to calculate work periods, overtime, and leave. Here’s how the calculator helps:
- Pay period calculation: If your pay period is "every 10 business days," use the calculator to find the end date of each period. For example, a pay period starting on June 1 ends on June 12 (skipping weekends).
- Leave tracking: Calculate how many business days an employee has taken off. For example, if an employee takes leave from June 1 to June 5, the calculator shows 5 business days (assuming no holidays).
- Overtime calculation: Determine how many business days an employee worked overtime. For example, if an employee worked late on June 1–3, the calculator confirms these are 3 business days.
- Holiday pay: Verify which holidays fall within a pay period and adjust payroll accordingly. For example, if July 4th falls on a Friday, the calculator will exclude it from the business-day count.
For example, if your pay period runs from June 1 to June 15, the calculator shows 11 business days. If an employee takes leave on June 3–4, the calculator confirms these are 2 business days, helping you adjust their pay accurately.
How Business Days Are Defined Around the World
While the Monday-to-Friday week is the global default, several regions follow different work-week patterns. In many Middle Eastern countries such as Saudi Arabia, the United Arab Emirates, and Qatar, the standard work week runs Sunday through Thursday, with Friday and Saturday considered the weekend. Israel uses Sunday through Thursday as well, with Friday and Saturday off. In some Latin American countries, Saturday may be a partial business day, particularly for retail and government offices.
Because these regional differences can change your business-day count by one or two days per week, it’s important to confirm the local definition before scheduling international projects or contracts. The Business Days Calculator uses the Monday-to-Friday convention, which matches the most widely used global standard. If you need a custom work week, you can simulate it by treating Friday or Saturday as a holiday in the holiday list—an easy workaround for cross-border planning.
International Public Holidays to Consider
Public holidays differ by country and can shift your business-day count significantly. Below are some of the most widely observed holidays that frequently affect international timelines:
| Holiday | Typical Date | Commonly Observed In |
|---|---|---|
| New Year’s Day | January 1 | Worldwide |
| Good Friday | Varies (March or April) | UK, Canada, Australia, parts of Europe |
| Easter Monday | Varies (March or April) | UK, much of Europe, Australia |
| Labor Day / May Day | May 1 | Most of Europe, parts of Asia and Africa |
| U.S. Independence Day | July 4 | United States |
| Canada Day | July 1 | Canada |
| Christmas Day | December 25 | Worldwide |
| Boxing Day | December 26 | UK, Canada, Australia, Commonwealth countries |
Adding these dates to the Business Days Calculator ensures your count reflects the working days available in your specific region. This is especially useful for multinational teams, cross-border contracts, and supply chains that span multiple jurisdictions.
See also: How to Calculate Absolute Value of Any Number.
Related reading: How to Calculate Calorie Deficit for Safe Weight Loss.
Related reading: How to Use the Chinese Gender Predictor for a Fun Baby Guess.