The formula
Friday–Saturday weekendExcelGoogle Sheets
=NETWORKDAYS.INTL(A2,B2,"0000110",D2:D3)In F2 → 22
Sunday only (6-day week)ExcelGoogle Sheets
=NETWORKDAYS.INTL(A2,B2,11,D2:D3)In F3 → 25
Sunday only (string version)ExcelGoogle Sheets
=NETWORKDAYS.INTL(A2,B2,"0000001",D2:D3)In F4 → 25
✓ Tested. All 3 Excel results in this example were recalculated in LibreOffice Calc 25.2 and matched the values shown.
Worked example
Paste the data below into a blank sheet starting at cell A1 (or download the cheat sheet, where every example is set up). Highlighted cells hold the formulas and show the expected results.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Start | End | Holidays | |||
| 2 | Dec 1, 2026 | Dec 31, 2026 | Dec 24, 2026 | 22 | ||
| 3 | Dec 25, 2026 | 25 | ||||
| 4 | 25 |
How it works
- "0000110"
- Monday→Sunday; 1 = weekend. Here Friday and Saturday are off.
- 11
- Built-in code for "Sunday only". 1 = Sat/Sun (default), 7 = Fri/Sat.
- D2:D3
- Optional holidays.
Common errors and fixes
Why does the formula return #VALUE!?
Weekend string isn't exactly 7 characters of 0/1, or is all 1s.
Why does the formula return #NUM!?
Invalid weekend number.
Does this work in Google Sheets?
Yes. The formulas on this page work the same way in Google Sheets.