Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Use Excel’s NETWORKDAYS function to count Monday–Friday working days between two dates, or NETWORKDAYS.INTL when your weekend differs. Both can exclude holidays you provide, and both count eligible start and end dates.
Count working days with a Saturday–Sunday weekend
Enter the start and end dates in separate cells, then use NETWORKDAYS. For example, if the dates are in A2 and B2:
As an Amazon Associate I earn from qualifying purchases.
=NETWORKDAYS(A2,B2)
The function returns whole working days, excluding Saturday and Sunday by default. It counts both endpoints when they fall on working days, so this is an inclusive count rather than simply the date difference minus weekends. Microsoft’s documentation illustrates the result as 110 working days from October 1, 2012 through March 1, 2013; excluding November 22, 2012 as a holiday makes the count 109. Microsoft’s NETWORKDAYS documentation
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Clear out junk files and repair common Windows errors3Scan for outdated or missing drivers - takes under a minuteExclude holidays from the count
Put each applicable holiday in its own cell as an actual Excel date, then supply that range as the third argument. For holidays in H2:H10:
#1 Best Overall
- Classic Office Apps | Includes classic desktop versions of Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, and presentations with ease.
- Install on a Single Device | Install classic desktop Office Apps for use on a single Windows laptop, Windows desktop, MacBook, or iMac.
- Ideal for One Person | With a one-time purchase of Microsoft Office 2024, you can create, organize, and get things done.
- Consider Upgrading to Microsoft 365 | Get premium benefits with a Microsoft 365 subscription, including ongoing updates, advanced security, and access to premium versions of Word, Excel, PowerPoint, Outlook, and more, plus 1TB cloud storage per person and multi-device support for Windows, Mac, iPhone, iPad, and Android.
=NETWORKDAYS(A2,B2,H2:H10)
Excel excludes a listed date only when it falls within the interval and would otherwise count as a workday. The function does not choose a holiday calendar: maintain a list appropriate to the relevant country, organization, or employee schedule, including the years covered by your calculation. Microsoft’s NETWORKDAYS documentation
Use a custom weekend schedule
For workweeks that do not use Saturday and Sunday as the weekend, use NETWORKDAYS.INTL:
=NETWORKDAYS.INTL(start_date,end_date,weekend,[holidays])
Rank #2
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.
For dates in A2 and B2, this example treats Sunday and Monday as nonworking days and excludes dates in H2:H10:
=NETWORKDAYS.INTL(A2,B2,2,H2:H10)
The third argument specifies the weekend; the optional fourth argument specifies holidays. You can use a numeric weekend code or a seven-character string ordered Monday through Sunday, where 1 marks a nonworking day and 0 a working day. For example, 0000011 marks Saturday and Sunday as nonworking. The string must contain seven characters using only 0 and 1, and it cannot mark all seven days as nonworking. Microsoft’s NETWORKDAYS.INTL documentation
Enter dates Excel can recognize
-
Place the start date and end date in separate cells.
Rank #3
![Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]](https://m.media-amazon.com/images/I/41H8B5iqO4L._SL160_.jpg)
Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]- [Ideal for One Person] — With a one-time purchase of Microsoft Office Home & Business 2024, you can create, organize, and get things done.
- [Classic Office Apps] — Includes Word, Excel, PowerPoint, Outlook and OneNote.
- [Desktop Only & Customer Support] — To install and use on one PC or Mac, on desktop only. Microsoft 365 has your back with readily available technical support through chat or phone.
-
Enter actual Excel date values, not ambiguous text. Microsoft recommends creating dates with
DATE(year,month,day)or using formula results if needed. Microsoft’s NETWORKDAYS documentationSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Enter each holiday date in its own cell, then pass the holiday range as the relevant function argument.
-
Choose
NETWORKDAYSfor a Saturday–Sunday weekend, orNETWORKDAYS.INTLfor a custom weekend pattern.Rank #4
Office Suite 2026 Special Edition for Windows 11-10-8-7-Vista-XP | PC Software and 1.000 New Fonts | Alternative to Microsoft Office | Compatible with Word, Excel and PowerPoint- THE ALTERNATIVE: The Office Suite Package is the perfect alternative to MS Office. It offers you word processing as well as spreadsheet analysis and the creation of presentations.
- LOTS OF EXTRAS:✓ 1,000 different fonts available to individually style your text documents and ✓ 20,000 clipart images
- EASY TO USE: The highly user-friendly interface will guarantee that you get off to a great start | Simply insert the included CD into your CD/DVD drive and install the Office program.
- ONE PROGRAM FOR EVERYTHING: Office Suite is the perfect computer accessory, offering a wide range of uses for university, work and school. ✓ Drawing program ✓ Database ✓ Formula editor ✓ Spreadsheet analysis ✓ Presentations
- FULL COMPATIBILITY: ✓ Compatible with Microsoft Office Word, Excel and PowerPoint ✓ Suitable for Windows 11, 10, 8, 7, Vista and XP (32 and 64-bit versions) ✓ Fast and easy installation ✓ Easy to navigate
Microsoft’s date-difference guide also uses NETWORKDAYS.INTL for this kind of calculation and shows the holiday range in the fourth argument. Microsoft’s date-difference guide
Choose the function that matches the result you need
| Need | Function | What it returns |
|---|---|---|
| Count workdays with Saturday and Sunday off | NETWORKDAYS |
A count; optional holiday range is the third argument |
| Count workdays with a custom weekend | NETWORKDAYS.INTL |
A count; weekend pattern is the third argument and optional holiday range is fourth |
| Move forward or backward by a number of workdays | WORKDAY or WORKDAY.INTL |
A resulting date, not a count between two dates |
Use WORKDAY when the schedule uses the standard weekend, or WORKDAY.INTL when it has a custom weekend; both support holidays. WORKDAY documentation and WORKDAY.INTL documentation
Handle reversed dates and common errors
-
The count is negative:
NETWORKDAYS.INTLreturns a negative count when the start date is later than the end date. If a report must always show a positive value, reorder the dates or useABS; that changes how the result is presented, not the interval’s direction. Microsoft documents a reverse-span example returning -21. Microsoft’s NETWORKDAYS.INTL documentationBest Value
Microsoft 365 Family | 12-Month Subscription | Up to 6 People | Premium Office Apps: Word, Excel, PowerPoint and more | 2TB Shared Cloud Storage | Windows Laptop or MacBook Instant Download | Activation Required- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- Up to 2 TB Shared Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Share Your Family Subscription | You can share all of your subscription benefits with up to 6 people for use across all their devices.
-
Excel returns
#VALUE!: Check that the date arguments are valid dates rather than text Excel could not parse. Microsoft’s NETWORKDAYS documentation -
The count is off by one: Check whether the start date and end date should count. A qualifying workday at either endpoint contributes to the result. Microsoft’s NETWORKDAYS documentation
-
A custom-weekend formula is rejected: Verify that the weekend string has seven characters, contains only 0 and 1, and does not mark all seven days as nonworking. Microsoft’s NETWORKDAYS.INTL documentation
DriversCrashes, No Sound, or Screen Glitches?PerformanceWindows Errors? Fix Them Before They SpreadDriversOutdated Drivers Are Slowing You DownSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Holidays are still being counted: Confirm that the holiday range contains actual dates for the relevant years. The function uses the dates supplied to it; it does not update or select a local holiday calendar for you. Microsoft’s NETWORKDAYS documentation
Quick Recap
Bestseller No. 1
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
