NETWORKDAYS Generator
Count the working days between two dates, skipping weekends and a list of holidays.
NETWORKDAYS
Count the working days between two dates, skipping weekends and a list of holidays.
Cell holding the first date. This day is counted when it falls on a weekday and is not in the holidays list.
Cell holding the last date. This day is counted too when it falls on a weekday and is not in the holidays list.
Range of dates to skip. Lock it with $ signs so it does not shift when you copy the formula down. This argument is optional - with no holiday list, delete it along with the comma before it.
=NETWORKDAYS(A2, B2, $E$2:$E$12)Worked Example
A2 holds 1/1/2026, B2 holds 1/31/2026, and the holidays range $E$2:$E$12 lists New Year's Day (1/1/2026).
=NETWORKDAYS(A2, B2, $E$2:$E$12)Returns: 21 - January 2026 has 22 weekdays, and New Year's Day (a Thursday) is deducted as a holiday.
Checks Before You Paste
- •NETWORKDAYS counts both endpoints, so Monday to Friday returns 5, not 4. Subtract 1 if you actually want elapsed days rather than days worked.
- •Weekends are hard-wired to Saturday and Sunday. For any other pattern use NETWORKDAYS.INTL(start, end, weekend, holidays) - weekend takes a code (1 = Sat/Sun, 7 = Fri/Sat, 11 = Sunday only) or a 7-character string starting at Monday, such as "0000011". It needs Excel 2010 or later, and works in Google Sheets.
- •If the answer shows up as a date like 1/21/1900, the cell inherited date formatting from its arguments - set it back to General or Number. Keep the holidays range as real date values rather than text that only looks like a date: format that column as a date and check the entries right-align. A start or end date Excel cannot read as a date returns #VALUE!.