How to Calculate Business Days in Excel

Whether you're tracking project deadlines, calculating invoice due dates, or figuring out how long a process actually takes — counting calendar days rarely tells the full story. Business days are what matter, and Excel has dedicated functions built specifically for this kind of work.

Here's exactly how those functions work, what variables affect the results, and why the "right" approach depends entirely on your situation.

What Counts as a Business Day?

A business day is any weekday that isn't a public holiday — typically Monday through Friday, excluding recognized holidays. The challenge is that weekends are universal, but holidays vary by country, region, company, and industry.

Excel's built-in date functions handle the weekend exclusion automatically. Holiday exclusion, however, requires you to supply that data yourself.

The Core Functions for Business Day Calculations

Excel offers two primary function pairs for business day math:

NETWORKDAYS — Count Business Days Between Two Dates

=NETWORKDAYS(start_date, end_date, [holidays]) 

This function counts the number of working days between a start and end date, inclusive of both dates. Weekends are automatically excluded. The optional [holidays] argument lets you pass a range of dates (like a holiday list on another sheet) to exclude those too.

Example:

=NETWORKDAYS("2024-01-01", "2024-01-31", A2:A10) 

This counts all working days in January 2024, minus any dates listed in cells A2 through A10.

WORKDAY — Find a Date That Is N Business Days Away

=WORKDAY(start_date, days, [holidays]) 

This function returns a future or past date that falls exactly a certain number of business days from a starting point. Useful for calculating deadlines — "what date is 10 business days from today?"

Example:

=WORKDAY(TODAY(), 10, A2:A10) 

Returns the date 10 working days from today, skipping weekends and any holidays in your list.

Handling Non-Standard Workweeks 📅

Not every organization runs Monday–Friday. Some industries use a Saturday workday, others have rotating schedules or operate Sunday–Thursday.

Excel accounts for this with extended versions of both functions:

Both accept a weekend parameter — either a number code or a 7-character string like "0000011" where each position represents a day (Monday–Sunday), and 1 means "this is a weekend day."

Example — Saturday and Sunday off (standard):

=NETWORKDAYS.INTL(start_date, end_date, 1, holidays) 

Example — Only Sunday off:

=NETWORKDAYS.INTL(start_date, end_date, 11, holidays) 

Example — Custom string (Friday and Saturday off):

=NETWORKDAYS.INTL(start_date, end_date, "0000110", holidays) 

Building a Holiday List That Actually Works

The [holidays] argument is only as accurate as the list you give it. A few things to get right:

• Format matters: Holiday dates must be in a format Excel recognizes as dates, not text strings. If NETWORKDAYS seems to be ignoring your holiday list, check whether those cells are formatted as dates or as text.
• Name your range: Define the holiday range as a named range (e.g., HolidayList) so your formulas stay readable and the list is easy to update.
• Keep it on a dedicated sheet: A single source-of-truth holiday tab prevents inconsistencies across formulas in your workbook.
• Update it annually: Excel won't pull in new holidays automatically — your list needs to reflect the actual calendar year in question.

Common Scenarios and the Right Function to Use

Where Things Get More Complex ⚙️

For most use cases, these four functions cover everything. But several variables can shift which approach works best:

Date formatting inconsistencies — If dates in your spreadsheet come from imports, external systems, or different regional formats, Excel may not recognize them correctly. Functions like DATEVALUE() can help convert text-formatted dates before running business day calculations.

Dynamic holiday lists — Some teams maintain holiday lists in shared workbooks or pull from external sources. If your holiday data is dynamic, you'll want to ensure your formula references update reliably.

Time zones and international teams — Excel doesn't natively account for time zones. If your team spans multiple countries with different holiday calendars, a single holiday list won't reflect the full picture — you may need separate calculations per region.

Excel vs. Google Sheets vs. other tools — Both NETWORKDAYS and WORKDAY exist in Google Sheets with nearly identical syntax. The .INTL variants are also available. However, behavior with edge cases and date formats can differ slightly across platforms.

Version differences — NETWORKDAYS.INTL and WORKDAY.INTL were introduced in Excel 2010. If you're working with older file formats or legacy systems, those functions may not be available or may not transfer correctly.

The Variable That Changes Everything

The mechanics of these functions are consistent — but how accurately they reflect your business days depends almost entirely on the inputs you provide and the structure of your specific workbook.

Whether you need regional holiday calendars, custom workweek definitions, cross-sheet references, or formulas that work across platforms — each of those factors shapes what a working solution actually looks like for your setup.