Goal: Count working days between Nov 1 and Nov 15.
NETWORKDAYS: Excludes Sat/Sun.
NETWORKDAYS.INTL: Custom weekends (e.g. Fri/Sat).
Ready...
💻 Formula Structure
=NETWORKDAYS(start, end, [holidays])
- Logic: Counts days between Start & End.
- Excludes: Saturdays, Sundays, and dates in [holidays].
=NETWORKDAYS.INTL(start, end, weekend, [hol])
- Weekend Code: 1 = Sat/Sun, 7 = Fri/Sat, 11 = Sun only.
- String Code: "0000011" (0=Work, 1=Off, Mon-Sun).
⚠️ Common Pitfalls
🚫 Inclusive Counting
Unlike simple subtraction (End - Start), this function is inclusive. Nov 1 to Nov 1 is 1 working day, not 0.