Calculate Weekdays Between Dates in Excel: Formulas

Formulas & functions · Updated November 19, 2026

To calculate weekdays between two dates in Excel, use =NETWORKDAYS(A2,B2), where A2 contains the start date and B2 the end date. It counts Monday through Friday and includes both dates when they fall on weekdays; add a holiday range or use NETWORKDAYS.INTL to change the rules.

What NETWORKDAYS Counts

NETWORKDAYS returns the number of working days in a date range, treating Saturday and Sunday as weekends by default. It is useful for counting business days in a project schedule, service period, delivery estimate, or timesheet. The function counts dates, not hours, and it does not calculate the number of calendar days elapsed.

The start and end dates are inclusive. For example, if the start date is Monday and the end date is Friday of the same week, all five weekdays count. If the range starts or ends on a Saturday or Sunday, that date contributes zero. A holiday is counted as a weekday unless you supply it separately as an excluded date.

Excel stores valid dates as serial numbers, so a cell can look like a date while still being understood by the function as a number. The result is a numeric count; format the result cell as General or Number if it appears with an unexpected date format.

Basic Formula and Worked Example

With the start date in A2 and the end date in B2, enter this formula in another cell:

=NETWORKDAYS(A2,B2)

For a concrete example, enter October 6, 2025, in A2 and October 10, 2025, in B2. Those dates are Monday and Friday, so the formula returns 5. The five counted dates are October 6, 7, 8, 9, and 10. If B2 instead contains October 11, a Saturday, the result remains 5 because Saturday is not a working day under the default weekend rule.

To use the formula, type dates into the cells or enter them using Excel’s date format, then select a result cell and type the formula. Press Enter in Excel for Microsoft 365 on Windows. The same function and formula syntax work in current Excel for Mac and Excel for the web; ribbon layout can differ, but no special setup is required. If you copy the formula down a table, the relative references A2 and B2 adjust for each row.

Exclude Public Holidays

Supply a third argument containing the dates to exclude as holidays. Put actual Excel dates in a range, rather than typing holiday names or date descriptions into the formula. A separate holiday list is easier to review and update from year to year.

With start and end dates in A2 and B2, and holiday dates in D2:D10, use:

=NETWORKDAYS(A2,B2,$D$2:$D$10)

If A2 is October 6, 2025, B2 is October 10, and D2 contains October 8, the answer is 4: the Wednesday holiday is removed from the five weekdays. The dollar signs keep the holiday range fixed when you fill the formula down. Blank cells in the holiday range are ignored, so a list can contain fewer entries than the full range allows.

Holiday dates should be real date values and should fall within the period to affect the count. A date outside the start-to-end range makes no difference. If a holiday falls on a Saturday or Sunday, it is already excluded by the default weekend rule; adding it again does not subtract another day. For an organization that observes a substitute weekday, enter the observed weekday in the holiday list.

Use a Different Weekend Pattern

Some work schedules do not use Saturday and Sunday as the weekend. NETWORKDAYS.INTL lets you specify which days are nonworking, while still allowing a holiday range. One clear option is a seven-character weekend string: the characters represent Monday through Sunday, and 1 marks a nonworking day while 0 marks a working day.

With dates in A2 and B2 and a Friday–Saturday weekend, use:

=NETWORKDAYS.INTL(A2,B2,"0000110")

For October 6–10, 2025, this returns 4: Monday through Thursday count, while Friday is part of the specified weekend. The string has seven positions in weekday order, so its fifth and sixth characters are 1 for Friday and Saturday. A Sunday-only weekend is represented by "0000001".

You can also provide holidays as the fourth argument. With A2 and B2 holding the dates, and D2:D10 holding holidays, this formula uses Friday and Saturday as weekends and excludes the listed holidays:

=NETWORKDAYS.INTL(A2,B2,"0000110",$D$2:$D$10)

Excel also accepts numeric weekend codes for common patterns, but the string is often easier to audit because each position directly identifies a day. Check the pattern carefully: a misplaced 1 can silently produce a plausible but incorrect count.

Decide Whether to Include the Endpoints

The word “between” can mean different things in everyday use. Excel’s NETWORKDAYS functions include both endpoint dates if they are working days. That convention is generally useful for a date range describing the first and last days of a job, leave period, or reporting window. It can surprise someone expecting the start date to be excluded, so confirm the counting rule before using the result in a report.

To count weekdays after the start date through the end date, with A2 as the start and B2 as the end, use:

=NETWORKDAYS(A2+1,B2)

For Monday October 6 through Friday October 10, this returns 4, counting Tuesday through Friday. To count only weekdays strictly inside both endpoints, use:

=NETWORKDAYS(A2+1,B2-1)

For the same Monday-to-Friday range, that formula returns 3 for Tuesday through Thursday. These adjustments are appropriate when the intended rule explicitly excludes one or both boundary dates. They are not a different mode built into NETWORKDAYS, so document the convention beside the result if others will use the workbook.

Prepare Dates and Troubleshoot Results

If a count looks wrong, first check the underlying values and the range boundaries. A cell that displays something date-like may contain text, especially if dates were copied from a web page or imported from a system with a different date convention. Text dates can cause an error or an unintended interpretation. Re-enter the value as a date or convert the source data to genuine Excel dates before relying on the count.

  • Check the year and regional order. A value such as 04/05/2025 can mean April 5 or May 4 depending on date settings. Use an unambiguous date entry or inspect the formula bar and cell formatting.
  • Check the holiday cells. Confirm they contain dates, not labels such as “Christmas,” and that the referenced range includes the relevant rows.
  • Check the weekend rule. NETWORKDAYS always uses Saturday and Sunday; use NETWORKDAYS.INTL for another schedule.
  • Check endpoint assumptions. Remember that working start and end dates are both included by default.
  • Check the result cell format. A number formatted as a date may display as a calendar date even though the calculation returned a count.

When source cells include timestamps, the safest practice is to make sure the inputs represent the intended calendar dates. A workday count is not a measure of elapsed shift time, and partial days do not become fractional workdays. If the requirement is to count hours or shifts, use a calculation designed for those units rather than treating NETWORKDAYS as an hour calculator.

NETWORKDAYS or NETWORKDAYS.INTL?

Choose NETWORKDAYS when the standard Monday-to-Friday workweek applies. Its shorter formula is easy to read and is suitable for most office calendars. Add a holiday range when designated weekdays should not count.

Choose NETWORKDAYS.INTL when the weekend differs, such as a Friday–Saturday weekend, or when the schedule needs a custom weekend pattern. It supports the same basic inclusive count and can also take a holiday range. Both functions return a count of workdays; neither returns a future date. If the task is instead to find a date a specified number of working days after a starting date, the related function is WORKDAY or WORKDAY.INTL, which calculates a date rather than counting the days in a range.

A simple calendar subtraction, such as B2 minus A2, answers a different question: it gives elapsed calendar days between the stored dates, not weekdays. It does not automatically remove Saturdays, Sundays, or holidays. Use the function that matches the intended measure, and keep the date inputs and workweek assumptions visible to anyone checking the workbook.

Frequently Asked Questions

Does NETWORKDAYS include the start and end dates?
Yes. It counts each endpoint if that date is a working day under the selected weekend pattern and is not listed as a holiday. A Saturday or Sunday is excluded by the default function even when it is an endpoint.

How do I count weekdays between dates while excluding holidays?
Place the holiday dates in a cell range and use that range as the third argument of NETWORKDAYS, or the fourth argument of NETWORKDAYS.INTL. The holiday cells must contain valid Excel dates.

Can Excel count a Sunday-to-Thursday workweek?
Yes. Use NETWORKDAYS.INTL and define Saturday and Friday as the weekend. Its seven-character weekend string is ordered Monday through Sunday, with 1 for days off and 0 for working days.

Why does my formula return a number that seems one day too high?
The function includes both endpoints when they are weekdays. If your rule excludes the start date, adjust the start argument by one day; if it excludes both endpoints, adjust both arguments. Confirm the intended rule before changing the calculation.

Does NETWORKDAYS count hours or partial days?
No. It counts whole working dates, not hours, shifts, or partial-day attendance. Use an hours-based calculation for time quantities.

Can I use these functions in Excel for Mac or the web?
Yes. NETWORKDAYS and NETWORKDAYS.INTL are available in current Excel for Mac and Excel for the web as well as Microsoft 365 for Windows. The formula logic is the same, though the surrounding interface may look different.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.