To calculate workdays between two dates in Excel, use NETWORKDAYS: with a start date in A2 and an end date in B2, enter =NETWORKDAYS(A2,B2). The function counts Monday through Friday, includes either endpoint when it falls on a workday, and can optionally exclude a list of holidays.
What Excel Means by Workdays
In the standard Excel workweek, workdays are Monday through Friday, while Saturday and Sunday are treated as weekend days. That definition is common for office schedules, but it is not universal: some businesses operate on weekends, and some regions use a different weekly rest pattern. Excel provides a separate function for those cases, covered below.
NETWORKDAYS counts qualifying dates in the range, including the start and end dates if they are workdays. It does not simply subtract one date from another. For example, a Monday-to-Friday range contains five workdays even though ordinary date subtraction gives four elapsed days. The distinction matters when calculating turnaround periods, staffing days, or the number of business days available to complete a task.
Both functions return whole numbers of workdays. They are not designed to calculate hours worked, partial shifts, or elapsed time between timestamps. If your cells include times as well as dates, decide whether the question is about calendar dates or working hours before choosing a formula.
Calculate Workdays with NETWORKDAYS
Put the starting date in A2 and the ending date in B2, then enter this formula in another cell:
With the start date in A2 and the end date in B2, use:
=NETWORKDAYS(A2,B2)
For example, January 6, 2025, is a Monday, and January 17, 2025, is a Friday. The formula returns 10: five weekdays in the first Monday-to-Friday span and five in the next. Saturdays and Sundays are not counted. If either endpoint is a Saturday or Sunday, that endpoint does not add a workday to the result.
The function’s basic syntax is NETWORKDAYS(start_date,end_date,[holidays]). The first two arguments are required; the holiday range is optional. The function can also return a negative result if the start date is later than the end date. If that is not appropriate for your report, check the date order or use a separate rule to handle reversed dates.
Exclude Holidays from the Count
To omit public holidays, company closure dates, or other nonworking dates that fall on weekdays, place those dates in a range and supply that range as the third argument. Holidays that fall on a Saturday or Sunday do not affect a standard Monday-to-Friday count because those dates were already excluded as weekends.
With the start date in A2, the end date in B2, and holiday dates in D2:D10, use:
=NETWORKDAYS(A2,B2,D2:D10)
Using the January 6–17, 2025 example, suppose D2 contains January 8, 2025, and that is the only listed holiday in the range. The result is 9 rather than 10. Excel excludes that Wednesday from the weekday count. A holiday outside the start-and-end range has no effect on the answer.
Keep the holiday list as real Excel dates, not text that merely looks like a date. You can enter dates directly into cells, or link the formula to a maintained holiday table. Using a range makes annual updates easier than inserting holiday dates into many individual formulas. If the list may grow, consider using an Excel Table column or a suitably sized range so new dates are included when the formula is updated.
Use NETWORKDAYS.INTL for Different Weekends
If your schedule has a weekend other than Saturday and Sunday, use NETWORKDAYS.INTL. It has the same basic purpose but lets you define which days are weekends. Its syntax is NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidays]). The weekend argument can specify a preset weekend pattern or a seven-character string that describes the week from Monday through Sunday. In that string, 1 means a nonworking day and 0 means a working day.
For a schedule where Sunday and Saturday are nonworking and Monday through Friday are working, the seven-character pattern is 0000011. With the start date in A2, the end date in B2, and holidays in D2:D10, use:
=NETWORKDAYS.INTL(A2,B2,"0000011",D2:D10)
This pattern gives the same weekend treatment as the default function, but makes the schedule explicit. To define another workweek, change the seven characters in Monday-to-Sunday order. For example, a schedule with Friday and Saturday off would use 0000110. Verify the pattern carefully: a misplaced 1 changes which dates are counted. The holiday argument remains optional, but when you provide holidays after a weekend argument, keep the argument positions in that order.
Check Dates, Cell Formats, and Results
A formula can be correct and still return an unexpected answer if the input cells are not genuine Excel dates. Excel stores dates as serial numbers and displays them using a date format. Text imported from another system may look like a date without being recognized as one, especially when the month and day order differs by region.
- Click each input cell and check that Excel recognizes it as a date; changing the display format alone does not convert text into a date.
- Confirm that the start date is in the intended start cell and the end date is in the intended end cell.
- Inspect the holiday range for text dates, blanks, accidental extra entries, or dates outside the relevant period.
- Check that your weekend definition matches the actual work schedule.
- Format the formula result as General or Number if it is displaying as a date or an unexpected decimal.
When Excel shows an error rather than a count, review the cell references and argument separators. In standard English-language Excel installations, formulas use commas between arguments, as in the examples here; some regional settings use semicolons instead. If the workbook is shared across computers with different regional settings, Excel may adjust separators when the file is opened.
Workdays, Calendar Days, and Working Hours
Use ordinary subtraction when you want elapsed calendar days, not business days. With a start date in A2 and an end date in B2, the formula =B2-A2 returns the difference in days between the dates; for January 6 and January 17, 2025, it returns 11. That is different from the 10 weekdays counted inclusively by NETWORKDAYS. Neither answer is inherently wrong: they answer different questions.
Another common misconception is that “between” always excludes both endpoints. Excel’s NETWORKDAYS convention includes qualifying start and end dates. If a process begins after the start date or finishes before the end date, adjust the dates or result to reflect that business rule rather than assuming the function uses an exclusive interval.
For hours or shifts, a workday count is not enough. A project may start at 3 p.m. and finish at 10 a.m. the next workday, or may include different daily working hours. That kind of calculation needs a schedule and time-of-day logic; subtracting two dates or counting workdays will not by itself produce accurate staffed hours.
Choose the Right Function for Your Schedule
For most Monday-to-Friday schedules, choose NETWORKDAYS. It is the shortest, clearest option and supports a holiday list. Use NETWORKDAYS.INTL when the weekend pattern differs, or when documenting the weekend explicitly improves clarity for people maintaining the workbook.
- Use
NETWORKDAYSfor a standard Saturday-Sunday weekend, with or without holidays. - Use
NETWORKDAYS.INTLfor nonstandard weekends, such as Friday-Saturday or a single weekly rest day. - Use date subtraction for calendar-day differences, not business-day counts.
- Use a separate hours or shift calculation when the question concerns working time within a day.
Both functions are available in current desktop Excel for Microsoft 365 on Windows. The same formulas are available in Excel for Mac and Excel for the web; ribbon layouts may differ, but these calculations do not require a particular ribbon command. Formulas recalculate when referenced dates or holidays change, which is useful for a schedule that is updated regularly.
Frequently Asked Questions
Does NETWORKDAYS include the start and end dates?
Yes. It counts either endpoint if that date is a working day under the selected weekend pattern. A weekend endpoint is excluded as a nonworking day.
How do I calculate workdays and exclude holidays?
Put the holiday dates in a cell range and use that range as the third argument of NETWORKDAYS, or the fourth argument of NETWORKDAYS.INTL when specifying a custom weekend.
How do I count workdays when Friday and Saturday are weekends?
Use NETWORKDAYS.INTL with the pattern 0000110, which marks Friday and Saturday as nonworking in Monday-to-Sunday order. Add a holiday range if needed.
Why is my workday result one day different from date subtraction?
Date subtraction measures elapsed calendar days, while NETWORKDAYS counts work dates inclusively and omits weekends and listed holidays. The figures follow different counting rules.
Can NETWORKDAYS calculate working hours?
No. It returns a count of whole working dates. For hours, you need to account for start and end times, daily schedules, breaks, and any relevant holidays or weekends.
Why does my formula return an error or an unexpected count?
Check that date and holiday cells contain real dates, the references point to the intended cells, and the weekend pattern is in the correct order. Also verify that your regional Excel settings accept the argument separator used in the formula.
Related
- Excel Find Duplicates and Count Matching Values Easily
- Excel Find Defined Names: Name Manager, Scope, and Uses
- Excel File With Table Filters: How to Add and Use Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Circular Reference Greyed Out? Find the CauseIn Excel for Microsoft 365 on Windows, the Circular References command is usually greyed out because Excel has…
- Excel Geographical Heat Map: Create and Troubleshoot OneIn Excel for Microsoft 365 on Windows, select a column of named geographic regions and a column of…
- How to Flip Column Order in Excel Without Moving RowsTo flip columns in Excel while keeping each column’s data together, add a temporary numbered row, select the…
- How to Archive Every Email in Outlook Step by StepTo archive every email in Outlook, open each mail folder, select its messages, and choose Archive; repeat for…
- Outlook Reading Pane: Change Its Position or Hide ItTo change the message panel in Outlook, open the View menu and choose a Reading Pane position: usually…
- Excel Shortcuts List: Essential Keys for Faster WorkFor Excel for Microsoft 365 on Windows, the most useful shortcuts include Ctrl+C and Ctrl+V to copy and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.