How to Calculate Business Days in Excel

Why Simple Date Subtraction Falls Short

When you subtract one date from another in Excel, you get total calendar days — weekends included. For payroll, project planning, SLA tracking, or delivery timelines, that raw number is almost always wrong. A shipment promised in "five business days" that falls over a long weekend is a completely different promise than one that covers only weekdays.

Understanding how Excel handles business days opens up a set of functions that are more useful than basic arithmetic. Once you know the right tools, you can build formulas that automatically skip weekends, exclude company holidays, and work correctly even when your team operates on a non-standard work week.

The NETWORKDAYS Function

The core function for business-day arithmetic in Excel is NETWORKDAYS. Its syntax is straightforward: =NETWORKDAYS(start_date, end_date). Excel returns the count of weekdays between those two dates, inclusive of both endpoints. If a project starts Monday and ends Friday of the same week, NETWORKDAYS returns 5.

One important nuance: both the start and end dates count as days in the result. If a deadline falls on a Wednesday and you need to count from the Monday before, the answer is 3 — Monday, Tuesday, and Wednesday. Many people forget this and end up off by one, especially when comparing formulas against calendar counts.

NETWORKDAYS also accepts a third optional argument: a range of holiday dates. Put your company holidays in a dedicated column on a separate sheet and reference that range in the formula. When you add or remove holidays from that list, every formula that references it updates automatically without manual edits.

Handling Non-Standard Work Weeks with NETWORKDAYS.INTL

Global teams often operate on work weeks that do not follow the Monday-to-Friday pattern. In many Middle Eastern countries, the working week runs Sunday through Thursday. Some retail or healthcare environments have rotating schedules that exclude Tuesday and Wednesday rather than Saturday and Sunday.

NETWORKDAYS.INTL handles this. The function adds a weekend parameter between the end date and the holiday range. You can either pass a code from Excel's built-in list (for example, 7 corresponds to Friday-Saturday) or a custom seven-character binary string where "1" marks a non-working day. A string of "0000011" means Saturday and Sunday are off, matching the standard US week.

This flexibility makes NETWORKDAYS.INTL the better default for multinational spreadsheets even if your current team uses a standard five-day week. It costs nothing extra to use and avoids a painful refactor later if your organization grows internationally.

Calculating a Future Deadline with WORKDAY

NETWORKDAYS counts days between two known dates. But what if you know a start date and want to find what date falls N business days later? That is the job of the WORKDAY function. The syntax is =WORKDAY(start_date, days, [holidays]).

If a contract is signed on Monday March 3 and payment terms are net 30 business days, =WORKDAY("2025-03-03", 30) returns the date that is 30 weekdays after the contract date — automatically skipping weekends. Add your holiday range as the third argument and holidays disappear from the count as well.

Like NETWORKDAYS, there is an international variant: WORKDAY.INTL accepts the same weekend codes or binary strings. The two pairs of functions work together: use WORKDAY.INTL to project forward, then NETWORKDAYS.INTL to verify the gap between any two resulting dates.

Common Mistakes and How to Avoid Them

• Forgetting inclusive endpoints: NETWORKDAYS counts both the start and end dates. Subtract one if your process actually starts "the day after" the reference date.

• Storing holidays as text: Excel only recognizes holiday dates if they are true date serial numbers. If they look like dates but are stored as text, they will not be excluded. Use Format Cells to confirm the type, or wrap entries with DATEVALUE.

• Mixing up WORKDAY and NETWORKDAYS: WORKDAY calculates a future or past date; NETWORKDAYS counts days between existing dates. Using the wrong function produces a number that looks plausible but is completely wrong.

• Ignoring time zones in global projects: NETWORKDAYS operates on calendar dates with no time-zone awareness. If a deadline is midnight UTC and your team is in Tokyo, the effective deadline may be a full day earlier in local time. Document the governing time zone in your spreadsheet header.

Cross-Checking With an Online Calculator

Spreadsheet formulas are powerful but easy to misconfigure, especially when holiday lists change or a formula is copied across sheets. Before sharing a timeline with a client or leadership, cross-check the critical dates with a dedicated weekdays calculator. An independent calculation that confirms your Excel output is a quick sanity check that costs seconds and can prevent costly misunderstandings.

Online business-day calculators are also useful when you need a fast answer and do not have access to your spreadsheet. Bookmark one alongside your other quick-reference tools for project management and payroll work.