Business Days in Excel & Google Sheets (With Holidays)
Learn the exact formulas to count and add business days in Excel/Sheets using weekends + holiday lists, with examples you can copy.
Read articleThe free, instant tool used by logistics, HR, finance and legal teams worldwide to calculate delivery dates, exclude public holidays, and plan international deadlines with confidence.
Calculate delivery dates excluding weekends and public holidays worldwide.
Quick links to popular country calculators — useful for bookmarking and sharing.
Official public holiday calendars sourced from government databases and updated annually for every country we support.
Results appear in milliseconds. No server round-trips — everything runs in your browser for maximum speed and privacy.
Include or exclude Saturdays as working days. Perfect for regions where Saturday is a business day.
Count forward to find a delivery date, or count backward to find a shipping deadline. Negative days supported.
Open the page, pick your country, and get your answer. No accounts, no subscriptions, no data collection.
Dedicated pages for every country with full holiday tables — perfect for bookmarking and sharing with colleagues.
Choose from 170+ countries. We load the official public holiday calendar for the current year.
Pick a start date, enter the number of business days to add (or subtract), and choose whether Saturdays count.
Instantly see the end date, a breakdown of skipped weekends and holidays, and which specific holidays were excluded.
Teams across industries rely on BizDays Global for deadline accuracy.
Calculate precise delivery windows for cross-border shipments accounting for local holidays at origin and destination.
Compute notice periods, probation end dates, and payroll deadlines that comply with local labor regulations.
Determine settlement dates, contract deadlines, and regulatory filing windows that exclude non-business days.
Plan international sprint timelines and milestone dates that account for team members in different countries.
A business day (also called a working day) is any day that is not a weekend or a public holiday. Most countries consider Monday through Friday as business days, though this varies by region.
We source holiday data from the open-source date-holidays library, which aggregates government-published holiday calendars. Data is updated regularly but we recommend verifying critical dates with local authorities.
Yes. Enter a negative number of business days to count backward from your start date. This is useful for finding shipping deadlines when you know the required delivery date.
Our tool focuses on national public holidays. Some countries have regional holidays that vary by state or province. For regional accuracy, always cross-reference with local government sources.
Yes, BizDays Global is completely free and always will be. No signup, no limits, no hidden features behind a paywall.
Manual counting is error-prone, especially across borders. Missing a single holiday can delay shipments, breach contract deadlines, or cause payroll miscalculations. Automating this eliminates human error.
Practical guides on business days, public holidays, and deadline planning for global teams.
Learn the exact formulas to count and add business days in Excel/Sheets using weekends + holiday lists, with examples you can copy.
Read articleNet terms are easy to misinterpret. Learn how Net 30 business days differs from Net 30 calendar days, with practical examples.
Read articleTurn lead times like “15 business days” into a real delivery date. Learn a reliable workflow that accounts for weekends and public holidays.
Read article