Date calculation guide Updated November 4, 2026 8 min read

How to Count Days Excluding Weekends and Holidays

To count days while excluding weekends and public holidays, first decide whether you need the number of working days or a breakdown of weekdays, weekends and holidays. Then define which endpoint dates count and use a holiday list that matches the calendar you are actually following.

Day Count Calculator editorial team
Day Count Calculator Editorial Team
Date calculation guides

Quick answer: For a business-day total in Excel or Google Sheets, use NETWORKDAYS with the start date, end date and a range containing holiday dates. If you also need to report how many days were weekdays, weekend days and holidays, calculate those categories separately so a holiday that falls on a weekend is not subtracted twice.

Examples on this page use Japan's calendar and an inclusive date range where stated. Company schedules, regional holidays and contractual rules can differ, so confirm the applicable calendar before using a count for a deadline or employment decision.


First decide: business-day total or a day-by-day breakdown?

The phrase “exclude weekends and holidays” can describe two different tasks. A delivery estimate or work schedule often needs one number: how many working days fall within a date range. A report or calendar review may instead need separate totals for all calendar days, weekdays, weekend days and public holidays. A working-day total cannot by itself tell you that breakdown.

Also decide whether the first and last dates are included. NETWORKDAYS counts eligible weekdays on both endpoints when they are weekdays. A simple subtraction, end date minus start date, measures elapsed days and does not count the start date as a day in the interval. Those results can differ by one even when every date is entered correctly.

QuestionWhat to count
How many workdays are available?Weekdays after applying the weekend pattern and holiday list
How many days of each type are in the period?Calendar days, weekdays, weekend days and holidays as separate categories
Does the first date count?State an inclusive or elapsed-day rule before choosing the formula

Set three rules before you calculate

A reliable count starts with a written rule, not a spreadsheet function. Two people can enter the same dates and get different answers if one counts the starting date, uses a Monday–Friday workweek and excludes national holidays, while the other uses a company calendar.

For a deadline, contract, leave period or payroll record, use the definition in the applicable policy. The examples here explain date arithmetic; they do not determine which rule an organization or agreement requires.

  • Choose the interval: elapsed days or both endpoints included.
  • Set the weekend pattern: Saturday and Sunday, or another schedule.
  • Prepare the holiday list: use actual date values and include only holidays that apply to this calendar.

A manual method for excluding weekends and holidays

For a short period, a calendar is enough. Write down every date in the range, mark its weekday, and then mark public holidays and any organization-specific closure days. Keep the labels separate: a public holiday can fall on a Saturday or Sunday, so it may belong in the holiday count without being removed from a weekday total.

If you need only working days, count weekdays that are not on the applicable holiday list. If you need a full breakdown, count each date once by its weekday and then report holiday overlap as a separate attribute. This avoids subtracting the same weekend holiday a second time.

  • List the start and end dates and mark whether both are included.
  • Label each date as a weekday or weekend using the relevant workweek.
  • Mark public holidays and company closures from the applicable calendar.
  • Count the requested categories and check that their totals reconcile with the calendar-day total.

Worked example: May 1 through May 10, 2026

This example uses Japan's calendar and counts both May 1 and May 10. The ten-day range contains six weekdays and four weekend days. Japan's May public holidays in the range are May 3, 4, 5 and 6; May 3 falls on Sunday, so it is already part of the weekend total.

For a Monday–Friday schedule, excluding the holidays leaves three working days: May 1, 7 and 8. The categories should be read with their definitions in mind. “Public holidays” counts four dates, while “weekdays excluding holidays” counts three dates; the Sunday holiday overlaps the weekend category.

CategoryCountHow it is counted
Calendar days, inclusive10May 1 through May 10
Weekdays6Monday through Friday dates
Weekend days4May 2, 3, 9 and 10
Public holidays4May 3, 4, 5 and 6
Weekdays excluding holidays3May 1, 7 and 8

Formulas for Excel and Google Sheets

For a Monday–Friday workweek, NETWORKDAYS is the direct choice when you want a count of workdays. If the start date is in A2, the end date is in B2, and holiday dates are in F2:F20, use =NETWORKDAYS(A2,B2,$F$2:$F$20). The function includes eligible weekdays on both endpoints and excludes the supplied holidays.

The holiday range should contain real spreadsheet dates, not text that only looks like a date. Keep notes in another column, remove blank or duplicate entries where practical, and use an absolute reference such as $F$2:$F$20 if the formula will be copied down a table.

If weekends are not Saturday and Sunday, use NETWORKDAYS.INTL and specify the weekend pattern. For a simple elapsed calendar-day difference use =B2-A2; to count both dates in that calendar range use =B2-A2+1. These formulas answer different questions.

  • =NETWORKDAYS(A2,B2) counts weekdays and excludes Saturday and Sunday.
  • =NETWORKDAYS(A2,B2,$F$2:$F$20) also excludes the dates listed in F2:F20.
  • Use NETWORKDAYS.INTL when the regular weekend days differ from Saturday and Sunday.
NeedFormula or approach
Workdays, standard weekend=NETWORKDAYS(A2,B2,holidays)
Workdays, custom weekend=NETWORKDAYS.INTL(A2,B2,weekend,holidays)
Elapsed calendar days=B2-A2
Calendar days including both endpoints=B2-A2+1

What to check when the result looks wrong

When a count differs from a calendar, check the rule and the input data before rewriting the formula. A one-day difference is often an endpoint convention; a larger difference can come from a missing holiday, a text-formatted date or the wrong weekend pattern.

For an auditable worksheet, keep the start date, end date, weekend rule and holiday range visible near the result. A formula is easier to review when another person can see which calendar it represents.

  • One day too many or too few: check whether the start and end dates should count.
  • A holiday is still counted: check that the holiday is a valid date inside the selected range.
  • The total is unexpectedly low: check for a weekend holiday entered as an extra deduction elsewhere.
  • A recurring schedule does not match: confirm the weekend pattern and any company closure dates.

Choose a calculator that matches the question

If you need the number of workdays between two dates, a business-day calculator is the closest match. If you need to see total days, weekdays, weekend days and holidays side by side, use a calendar breakdown tool. Those outputs are related, but one is not a substitute for the other.

The site's calendar breakdown calculator is currently available in Japanese. For spreadsheet formulas and a comparison of date-difference methods, see the English guide to Excel day-count formulas. Use the displayed result as a check, then confirm the calendar and counting rule needed for your situation.


Summary: define the range and holiday calendar first

To count days excluding weekends and holidays, decide whether you need business days or a category breakdown, then set the endpoint and weekend rules. For a standard workweek, NETWORKDAYS can count weekdays while excluding a supplied holiday range. NETWORKDAYS.INTL supports other weekend patterns.

For a breakdown, count weekdays, weekend dates and holidays separately and report overlaps clearly. In the May 1–10, 2026 Japan example, the inclusive range has ten calendar days, six weekdays, four weekend days, four public holidays and three weekdays after holidays are excluded. Check the relevant policy before using a general example for a formal deadline.

Frequently asked questions

How do I count days excluding weekends and holidays in Excel?

Use =NETWORKDAYS(start_date,end_date,holiday_range). The function counts Monday–Friday dates, includes eligible endpoints and excludes dates in the holiday range.

Does NETWORKDAYS include the start and end dates?

It checks both endpoints and counts an endpoint when it is a weekday that is not excluded as a holiday. Confirm whether that inclusive rule matches your task.

How do I exclude Japanese public holidays in Google Sheets?

Enter the applicable holiday dates in a range and use it as the third argument, for example =NETWORKDAYS(A2,B2,F2:F20). The function does not automatically determine which country's holiday calendar applies.

What if my weekend is not Saturday and Sunday?

Use NETWORKDAYS.INTL and set the weekend argument to match the schedule. Check the spreadsheet documentation for the weekend code or pattern syntax supported by your version.

How can I count weekdays, weekends and holidays separately?

Count the date range by weekday, then compare dates against the applicable holiday list. Track overlap explicitly: a public holiday on a Saturday is both a holiday and a weekend date, but it is not an extra weekday deduction.

Why is my result one day different?

The formula may be counting both endpoints while your manual calculation uses elapsed days, or the reverse. Compare the stated rule with =B2-A2 and, when both dates count, =B2-A2+1.

Are public holidays automatically excluded by NETWORKDAYS?

No. Provide holiday dates as the optional holiday argument. A company may also have closure days that are not national public holidays, so use the calendar required for your purpose.

Official references and function documentation

Verify public-holiday dates against the calendar that applies to your location, and check spreadsheet function behavior in the software documentation.

  1. Japan Cabinet Office: National Holidays (Japanese-language source)
  2. Microsoft Support: NETWORKDAYS function (Japanese-language source)
  3. Google Docs Editors Help: NETWORKDAYS (Japanese-language source)

Related date-calculation pages