Use Excel’s NETWORKDAYS function to count Monday-to-Friday workdays between two dates, optionally excluding holidays: =NETWORKDAYS(start_date,end_date,[holidays]). It counts both the start and end dates when they are workdays, so the result is an inclusive count—not simply the number of days elapsed.
How NETWORKDAYS Counts Workdays
NETWORKDAYS is designed for counting working days in a date interval. By default, it treats Saturday and Sunday as weekends and excludes them. You supply a start date and an end date, and you can optionally supply a range of holiday dates to exclude as well. The function returns a whole number.
The square brackets in the function’s written syntax indicate an optional argument; do not type the brackets into the formula. In a worksheet, the basic formula has this form:
With the start date in A2 and the end date in B2, and no holiday list, use =NETWORKDAYS(A2,B2).
Excel needs to recognize the cell contents as dates. Dates entered into cells and formatted as dates are usually suitable; a cell that only looks like a date but contains text can cause an error or an unexpected result. The calculation uses the underlying date values, not the way they are displayed. A date formatted as “Jan 2” and the same date formatted as “1/2/2025” represent the same day if both are genuine Excel dates.
This function is available in Microsoft 365 Excel for Windows, Mac, and the web. The function name and arguments are the same across those editions. If your regional settings use semicolons as formula separators, Excel may display semicolons instead of commas, but the examples here use the standard comma-separated syntax.
Worked Example: Count Weekdays in a Date Range
Suppose A2 contains January 2, 2025, and B2 contains January 8, 2025. The interval covers Thursday, Friday, Saturday, Sunday, Monday, Tuesday, and Wednesday. Saturday and Sunday are excluded, leaving five workdays.
With January 2, 2025 in A2 and January 8, 2025 in B2, use =NETWORKDAYS(A2,B2); the result is 5.
Notice that January 2 and January 8 both count because they fall on weekdays. There are six elapsed calendar days from January 2 to January 8, but five weekdays in the inclusive date range. That difference explains why a workday count may not match a simple subtraction of the dates.
For a comparison, if A2 contains January 2, 2025 and B2 contains January 8, 2025, use =B2-A2 to calculate elapsed calendar days; the result is 6. This subtraction does not remove weekends or holidays. It answers a different question from NETWORKDAYS.
Exclude Holidays from the Count
Put official holidays or other nonworking dates in a worksheet range, with one Excel date per cell. Then provide that range as the third argument. Holidays can be listed in any order, and the range may include more dates than fall within the period; only dates that affect the interval change the count.
With the start date in A2, the end date in B2, and holiday dates in C2:C10, use =NETWORKDAYS(A2,B2,C2:C10).
For the January 2–8, 2025 example, if C2 contains January 6, the result is 4: Thursday, Friday, Tuesday, and Wednesday count, while the weekend and Monday’s holiday do not. A holiday that falls on Saturday or Sunday does not reduce the count further, because weekend dates are already excluded. If your organization observes a substitute day on a weekday, enter that observed date in the holiday list too.
Keep the holiday list as real dates rather than text labels. You can label the dates in a neighboring column—for example, “New Year’s Day”—without including the labels in the holiday argument. When copying the formula down a table, consider locking the holiday range so it does not shift. With dates in A2 and B2 and a fixed holiday list in C2:C10, use =NETWORKDAYS(A2,B2,$C$2:$C$10); the dollar signs keep the holiday range fixed when the formula is filled to other rows.
Set a Different Weekend Schedule
Not every workplace treats Saturday and Sunday as nonworking days. Use NETWORKDAYS.INTL when the weekend is different, such as Friday and Saturday, or when a particular day is the only weekly day off. It accepts a weekend argument in addition to the dates, and it can also accept a holiday range.
The weekend argument can use a code or a seven-character pattern. In a pattern, the characters represent Monday through Sunday, in that order: 1 means a nonworking day and 0 means a working day. For example, “0000110” marks Friday and Saturday as weekends. This makes it possible to describe schedules that do not fit the usual Saturday-and-Sunday pattern.
With the start date in A2, the end date in B2, a Friday–Saturday weekend, and holiday dates in C2:C10, use =NETWORKDAYS.INTL(A2,B2,"0000110",C2:C10).
Check the pattern carefully before relying on it: the first character is Monday, not Sunday. A misplaced 1 can silently exclude the wrong days. The function can also represent weekends with numeric codes, but the text pattern is often easier to audit because each position visibly corresponds to a day of the week. Use a schedule that matches the actual work calendar, not merely the most common weekend.
Inclusive Counts and Dates in Reverse Order
A common source of confusion is what “between” means. NETWORKDAYS includes both endpoints when they are working days. If a project starts on Monday and ends on Friday, it counts five workdays, not four. If you intend to count the start day as day zero and count only workdays after it through the end date, adjust the start date by one calendar day.
With the starting date in A2, the ending date in B2, and holidays in C2:C10, use =NETWORKDAYS(A2+1,B2,C2:C10) to count workdays after the start date through the end date. For a Monday-to-Friday interval with no holidays, that interpretation returns four rather than five. This adjustment is appropriate only when the dates run forward and the starting date should be excluded. If the start date is a weekend or a holiday, decide whether your business rule is about excluding that particular date or counting from the next workday; those are not always the same policy.
If the dates are reversed, Excel can return a negative workday count. That may be useful for showing how far a deadline has passed, but it can be confusing in a report that expects nonnegative durations. Check the input order or define explicitly how reversed dates should be handled. Avoid silently changing the order unless that matches the meaning of your calculation.
Common Problems and Checks
If the result is wrong or Excel shows an error, check the inputs before changing the formula. The most frequent problems are date values stored as text, an incorrectly ordered date range, and a holiday range that includes labels or misses an observed day.
- Verify that both endpoints are dates. Change the cell format temporarily to General. A genuine Excel date will display as a number; text may remain text. Re-enter or convert text dates using a method appropriate to their format and regional settings.
- Check the holiday cells. Each cell in the holiday argument should contain a date value. Blank cells in a larger holiday range are generally harmless, but text descriptions are not substitutes for date entries.
- Confirm the weekend definition. The regular
NETWORKDAYSfunction always uses Saturday and Sunday as weekends. UseNETWORKDAYS.INTLfor a different weekly schedule. - Review inclusivity. Make sure the business question expects both boundary dates to count when they are workdays. An inclusive count and elapsed days are different measures.
- Inspect the formula separators. If Excel rejects commas, your regional settings may require semicolons. Let Excel insert function arguments or replace separators according to your installation’s conventions.
A zero result does not automatically mean the formula failed. It can mean that the interval contains no workdays after weekends and listed holidays are excluded. For example, a Saturday-to-Sunday range contains no default workdays. A negative result can indicate that the start date is later than the end date.
When to Use Another Excel Function
Use NETWORKDAYS when you need the number of working days in a date range. Choose NETWORKDAYS.INTL when the weekly weekend differs from Saturday and Sunday. Neither function returns a date; they return counts.
If you need to calculate a date a set number of working days from a starting date, Excel’s WORKDAY function is the related tool for the standard weekend. WORKDAY.INTL provides a custom weekend schedule. These functions solve the reverse task: rather than counting workdays between two dates, they calculate a future or past working date based on a number of workdays. You still need to decide how holidays and the starting day should be treated for your particular process.
For calendar-day duration, subtract the earlier date from the later date instead of using a workday function. For hours or shifts, neither a simple date subtraction nor NETWORKDAYS captures a detailed schedule by itself. You may need start and finish times, break rules, shift calendars, or a more specific calculation. Choose the function that corresponds to the quantity you actually want to report.
Frequently Asked Questions
Does NETWORKDAYS count the start and end dates?
Yes. It counts either endpoint if that date is a workday under the selected weekend pattern and is not listed as a holiday. This is why a Monday-to-Friday range returns five.
How do I count workdays excluding holidays?
Put holiday dates in a range and pass that range as the third argument to NETWORKDAYS. For a nonstandard weekend, use NETWORKDAYS.INTL and provide both the weekend definition and holiday range.
Can NETWORKDAYS calculate workdays with a Friday–Saturday weekend?
Yes. Use NETWORKDAYS.INTL and specify the weekend pattern or a supported weekend code. In a seven-character pattern, positions run Monday through Sunday, with 1 for a nonworking day.
Why is my workday result one day higher than expected?
The function counts both boundary dates when they qualify as workdays. If your intended measure excludes the start date, adjust the calculation to reflect that rule; do not assume “between” means exclusive.
What is the difference between NETWORKDAYS and WORKDAY?NETWORKDAYS returns the number of working days between two dates. WORKDAY returns a date reached by moving a specified number of working days from a starting date. Use their INTL counterparts when the weekend schedule is nonstandard.
Related
- Excel Data Validation List Without a Cell Reference?
- Excel Data Validation List: Can You Select Multiple?
- Excel Data Validation List: Remove Duplicates
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Table Drag Formula: Lock Cell ReferencesTo keep a cell reference fixed when you fill a formula down an Excel table, add dollar signs…
- Gtt per Min Formula: Examples and Safe CalculationThe gtt per min formula is gtt/min = (mL × drop factor in gtt/mL) ÷ time in minutes.…
- Excel Percent Change Formula and ExamplesTo calculate percent change in Excel, subtract the old value from the new value, then divide by the…
- Excel Midpoint of Dates: Formula and ExamplesTo find the midpoint between two dates in Excel, put the earlier date in A2 and the later…
- Excel Data Analysis Books: How to Choose the Right OneGood Excel data-analysis books include Microsoft Excel Data Analysis and Business Modeling by Wayne L. Winston for business…
- Excel Nested Formula Examples and How They WorkExcel nested formulas place one function inside another, so a calculation or test can supply the input for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.