Custom weekends · US, UK and India holidays · any year
Business Days Calculator for Working Days Between Dates
Count the working days between two dates, or add business days to a date to find a deadline. This business days calculator handles any weekend pattern, including India’s 2nd and 4th Saturday bank holidays, public holidays and your own days off.
- Between dates or add days
- Any weekend pattern
- Holidays for any year
- Month-by-month breakdown
- 261Working days in 2026 with Sat–Sun weekends, before holidays
- 4Weekend patterns, plus custom days off
- 3Countries’ public holidays built in
- AnyYear, calculated automatically
Built for real schedules
Why use this business days calculator
Most working day calculators assume a Monday-to-Friday week and US holidays. Work is rarely that simple, especially in India.
Two calculators in one
Count working days between two dates, or add and subtract business days to find a deadline or delivery date.
Any weekend pattern
Saturday and Sunday, Sunday only, Friday and Saturday, Indian bank weekends, or any mix of days you choose.
Holidays for any year
US federal and UK bank holidays are worked out for any year, including moved dates when a holiday falls on a weekend.
Your own days off
Add festivals, state holidays, company shutdowns or planned leave, each with a name.
Month-by-month view
See how many working days fall in each month, plus working hours and every holiday skipped.
Matching Excel formula
Get the NETWORKDAYS.INTL or WORKDAY.INTL formula that gives the same answer in your spreadsheet.
Takes seconds
How to use the business days calculator
Five quick steps.
Pick what to calculate
Choose days between two dates, or add and subtract business days from a start date.
Enter the dates
Pick the start and end dates, and whether the first and last days should count.
Set your weekend
Choose a weekend pattern or tap the days you do not work.
Choose holidays
Select your country’s public holidays and add any extra days off.
Read the result
See working days, hours, the monthly split and the holidays that were skipped.
The method
How business days are calculated
A business day, or working day, is any day that is not a weekend day or a public holiday. To count them, list every date in the range, remove the weekend days, then remove holidays that fall on the remaining weekdays.
Adding business days works the other way. Start from a date, move forward one day at a time, and count only the days that are working days until you reach the number you need.
Business days vs calendar days
Contracts, notice periods and delivery promises often say “business days”. Ten business days is usually two full weeks, or 14 calendar days, and longer if a holiday falls in between.
Weekends around the world
Most countries rest on Saturday and Sunday. Many Middle Eastern countries use Friday and Saturday, and some businesses in India work six days a week with only Sunday off. Indian banks close on the 2nd and 4th Saturday of each month.
Need calendar days instead? Use our date calculator.
Business day formula
Business days = Calendar days − Weekend days − Weekday holidaysIn Excel or Google Sheets:
=NETWORKDAYS(A2, B2, Holidays)=NETWORKDAYS.INTL(A2, B2, 11, Holidays)The 11 means only Sunday is a weekend. Use WORKDAY.INTL to add business days to a date.
Reference
Public holidays in 2026
The holidays this calculator uses by default. Dates moved because of a weekend are shown as the day off.
| Holiday | Date |
|---|---|
| Republic Day | Mon, 26 Jan |
| Independence Day | Sat, 15 Aug |
| Gandhi Jayanti | Fri, 2 Oct |
| Holiday | Date |
|---|---|
| New Year’s Day | Thu, 1 Jan |
| Martin Luther King Jr. Day | Mon, 19 Jan |
| Presidents’ Day | Mon, 16 Feb |
| Memorial Day | Mon, 25 May |
| Juneteenth | Fri, 19 Jun |
| Independence Day | Fri, 3 Jul |
| Labor Day | Mon, 7 Sep |
| Columbus Day | Mon, 12 Oct |
| Veterans Day | Wed, 11 Nov |
| Thanksgiving Day | Thu, 26 Nov |
| Christmas Day | Fri, 25 Dec |
| Holiday | Date |
|---|---|
| New Year’s Day | Thu, 1 Jan |
| Good Friday | Fri, 3 Apr |
| Easter Monday | Mon, 6 Apr |
| Early May bank holiday | Mon, 4 May |
| Spring bank holiday | Mon, 25 May |
| Summer bank holiday | Mon, 31 Aug |
| Christmas Day | Fri, 25 Dec |
| Boxing Day | Mon, 28 Dec |
India also has many festival and state holidays that change every year. Add the ones your office follows as extra days off.
Answers
Business days calculator FAQs
How do I calculate business days between two dates?
Count all the days in the range, subtract the weekend days, then subtract any public holidays that fall on weekdays. This calculator does it for you and lets you choose whether the start and end dates count.
How many business days are in a year?
With Saturday and Sunday weekends, most years have 260 or 261 weekdays. 2026 has 261. Subtract your public holidays to get the number of working days.
How many business days is 2 weeks?
Two weeks is 10 business days with a Monday-to-Friday week, or fewer if a public holiday falls in that time.
Are Saturdays business days?
Usually not. In most countries business days are Monday to Friday. Some businesses in India work on Saturdays, and Indian banks close only on the 2nd and 4th Saturdays.
Does the count include the start and end dates?
You can choose. By default both dates are counted, which matches the NETWORKDAYS function in Excel. Untick either box to leave that date out.
How do I add business days to a date?
Choose Add or subtract days, pick a start date and enter the number of business days. The calculator skips weekends and holidays and shows the resulting date. The start date itself is not counted.
Which holidays are included for India?
The national holidays: Republic Day on 26 January, Independence Day on 15 August and Gandhi Jayanti on 2 October. Festival and state holidays change every year, so add the ones you follow as extra days off.
How are US federal holidays handled when they fall on a weekend?
A holiday that falls on a Saturday is observed on the Friday before, and one on a Sunday is observed on the Monday after. The calculator uses these observed dates.
How do I count business days in Excel?
Use =NETWORKDAYS(start, end, holidays) for a Monday-to-Friday week, or =NETWORKDAYS.INTL(start, end, weekend, holidays) for other weekends. Use WORKDAY or WORKDAY.INTL to add business days to a date.
Plan deadlines you can actually meet
Use the business days calculator for project plans, notice periods, delivery dates and payroll, with your own weekends and holidays.
Count my working daysResults depend on the weekends and holidays you choose. Always check official holiday calendars for your state, employer or bank.