TodayFree forever - no sign-up, no paid plans

NETWORKDAYS.INTL - How to Count Business Days with a Custom Weekend

By Daniel Mercer · Updated October 26, 2026

Open the Business Days Calculator

The plain NETWORKDAYS function assumes your weekend is Saturday and Sunday. For a large part of the world - and for plenty of businesses inside the United States - that assumption is wrong. Retail and hospitality run weekends that include Saturday. Some countries rest on Friday and Saturday. Nepal takes Saturday as its only weekly day off. For all of these, Excel provides NETWORKDAYS.INTL, the version of the function that counts business days with a custom weekend. This guide covers the syntax, the weekend codes, the string method, and a worked example showing how much the answer moves when the weekend changes.

The syntax

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]). The first two arguments are the same dates you would give NETWORKDAYS, and like NETWORKDAYS it counts both endpoints when they are working days. The third argument is the new part: a weekend code from the table below, or a text string that defines the weekend day by day. The fourth argument is the optional holiday range, in fourth position - a detail that trips people up, because in NETWORKDAYS the holidays sit in third position.

CodeWeekend daysCodeWeekend days
1Saturday, Sunday11Sunday only
2Sunday, Monday12Monday only
3Monday, Tuesday13Tuesday only
4Tuesday, Wednesday14Wednesday only
5Wednesday, Thursday15Thursday only
6Thursday, Friday16Friday only
7Friday, Saturday17Saturday only

Omitting the weekend argument, or using code 1, gives you exactly the NETWORKDAYS answer. The codes worth memorizing are 7 (Friday-Saturday, used across much of the Middle East historically and still in several countries), 11 (Sunday only, for six-day operations that close on Sunday) and 17 (Saturday only, the pattern in Nepal, where the working week runs Sunday to Friday).

The weekend string: any pattern at all

Codes cover the common patterns, but a string covers everything. The string has exactly seven characters, one per day starting with Monday. A 1 marks a weekend day and a 0 marks a working day, and the string must be wrapped in quotes. Examples:

PatternStringReading it
Saturday-Sunday weekend"0000011"Only the last two characters (Sat, Sun) are 1
Friday-Saturday weekend"0000110"Friday and Saturday are 1, Sunday is 0
Sunday only"0000001"Only Sunday is a day off
Saturday only"0000010"Only Saturday is a day off
Wednesday and Sunday off"0010001"A split pattern no code can express

The classic error is writing the string starting with Sunday. Excel starts with Monday, so a string built on the wrong day silently shifts the whole weekend by one position and returns a plausible-looking wrong answer. Whenever you build a string, test it on a single known week before trusting it on a year of data.

Counting business days with a custom weekend in NETWORKDAYS.INTL

Worked example: one span, three weekends

Take Monday, January 5 to Monday, January 19, 2026 - fifteen calendar days, both endpoints counted, no holiday list for the moment. The same span under three different weekends:

FormulaWeekendResult
=NETWORKDAYS.INTL(A2,B2,1)Saturday-Sunday11 working days
=NETWORKDAYS.INTL(A2,B2,7)Friday-Saturday11 working days
=NETWORKDAYS.INTL(A2,B2,11)Sunday only13 working days

The first two agree by coincidence of this span: it contains two Saturdays and two Sundays, and also two Fridays and two Saturdays, so both weekends remove four days. The Sunday-only weekend removes just the two Sundays (January 11 and 18), leaving 13. Over a quarter or a year the patterns pull apart quickly, which is why a payroll or SLA spreadsheet for an international operation should never quietly use the default. Add the holiday range as the fourth argument and the function also removes the holidays of whichever country you list - the federal list for a US count, or a local list for a local weekend. If you are counting for a United States deadline, the plain business days calculator already applies the Saturday-Sunday weekend and the federal holidays together, and the homepage calculator shows the same figure for any span.

WORKDAY.INTL: the companion function

Everything above has a mirror image. WORKDAY.INTL takes a start date, a number of working days, the same weekend code or string, and an optional holiday list, and returns the resulting date. It is how you answer "what date is 10 working days from now?" for a team whose weekend is not Saturday-Sunday. Like WORKDAY, it does not count the start date, and a negative count walks backwards. If you are new to the plain versions, start with our guide to NETWORKDAYS in Excel, then come back here when the weekend stops cooperating. Google Sheets supports both INTL functions with identical syntax, which our Google Sheets guide covers.

Adding holidays under a custom weekend

The holiday argument works under any weekend pattern, and the January span shows why it matters. Under the Friday-Saturday weekend (code 7), the count from January 5 to January 19, 2026 was 11 - and Martin Luther King Jr. Day, Monday, January 19, is a working day under that pattern, because Mondays are worked. Pass a holiday list containing January 19 as the fourth argument - =NETWORKDAYS.INTL(A2,B2,7,Holidays) - and the result drops to 10. The general principle: a holiday only changes the answer if it falls on a day your pattern treats as a working day. Under a Saturday-Sunday weekend, a Saturday holiday never needs listing; under a Friday-Saturday weekend, a Monday holiday absolutely does. When you build counts for another country, pair that country's weekend with that country's holiday list - mixing a Friday-Saturday weekend with a US holiday list, or the reverse, produces numbers that look reasonable and are quietly wrong for both places.

Frequently asked questions

What does NETWORKDAYS.INTL do that NETWORKDAYS does not?

NETWORKDAYS always treats Saturday and Sunday as the weekend. NETWORKDAYS.INTL adds a weekend argument, so you can count business days with a Friday-Saturday weekend, a single day off, or any custom pattern you define with a seven-character string.

What is the weekend code for a Friday-Saturday weekend?

Code 7. The two-day weekend codes run from 1 (Saturday-Sunday) to 7 (Friday-Saturday). Codes 11 to 17 set a single weekend day, from Sunday only (11) to Saturday only (17).

How does the seven-character weekend string work?

The string has one character per day, starting with Monday. A 1 means the day is a weekend day and a 0 means it is a working day. A Friday-Saturday weekend is 0000110, and a Sunday-only weekend is 0000001.

Does NETWORKDAYS.INTL also remove holidays?

Yes, if you give it the optional holidays argument, exactly as with NETWORKDAYS. The weekend argument comes third and the holiday range fourth: =NETWORKDAYS.INTL(start, end, weekend, holidays).

Is there a WORKDAY version for custom weekends?

Yes - WORKDAY.INTL. It takes the same weekend codes and strings and returns the date a set number of working days before or after a start date, skipping your custom weekend and any holidays you list.

Related guides

How to calculate business days in Excel with NETWORKDAYS

The base formula, the holiday argument, and the inclusive-counting trap.

Weekends are not always Saturday and Sunday

How different countries set their weekends, and what it does to deadlines.

How to calculate business days in Google Sheets

The same functions in Sheets, with a holiday list and worked examples.

How to exclude holidays from a business day count

Building a holiday list that matches the country you are counting for.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.