NETWORKDAYS vs NETWORKDAYS.INTL
NETWORKDAYS assumes a Saturday–Sunday weekend; NETWORKDAYS.INTL lets you choose the days off.
| NETWORKDAYS | NETWORKDAYS.INTL | |
|---|---|---|
| Weekend | Always Saturday and Sunday | Your choice: a code or "0000011" |
| Business open Monday to Saturday | Does not work | Code 11 |
| Holidays | Third argument | Fourth argument |
Syntax and example
NETWORKDAYS
=NETWORKDAYS(start_date, end_date, [holidays])
=NETWORKDAYS(B2,C2,$F$2:$F$4)
Counts working days (Monday to Friday) between two dates, both included, minus the holidays you list.
NETWORKDAYS.INTL
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
=NETWORKDAYS.INTL(B2,C2,11,$G$2:$G$4)
Counts the work days between two dates with the weekend you choose.
Which one to use?
If you rest on Saturday and Sunday, either one. For shops, restaurants or other schedules, NETWORKDAYS.INTL.
About Ads
This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.
Ads help us keep WebHerramientas free for everyone
Practice it
Solve the exercise on the sheet; it is checked instantly. See all lessons · Formula translator
Work days Monday to Saturday
NETWORKDAYS and WORKDAY assume Saturday and Sunday off. Their .INTL versions accept another weekend: 11 is Sunday only, 7 is Friday and Saturday, or a text such as "0000011" (1 = day off, Monday to Sunday). The last argument is the holidays.
=NETWORKDAYS.INTL(B2,C2,11,$G$2:$G$4)DIAS.LAB.INTL = NETWORKDAYS.INTLDIA.LAB.INTL = WORKDAY.INTLIn D2, count the work days between start and end for a business open Monday to Saturday, excluding the holidays in G2:G4.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Start | End | Work days | Due in 15 days | Holidays | ||
| 2 | P-101 | 03/03/2025 | 03/28/2025 | 03/17/2025 | ||||
| 3 | P-102 | 04/07/2025 | 04/30/2025 | 04/18/2025 | ||||
| 4 | P-103 | 04/28/2025 | 05/16/2025 | 05/01/2025 | ||||
| 5 | P-104 | 03/10/2025 | 03/21/2025 | |||||
| 6 | P-105 | 05/05/2025 | 06/06/2025 | |||||
| 7 |
Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.
Frequently asked questions
- What is the difference between NETWORKDAYS and NETWORKDAYS.INTL?
- NETWORKDAYS assumes a Saturday–Sunday weekend; NETWORKDAYS.INTL lets you choose the days off.
- When should I use NETWORKDAYS or NETWORKDAYS.INTL?
- If you rest on Saturday and Sunday, either one. For shops, restaurants or other schedules, NETWORKDAYS.INTL.