NETWORKDAYS: Working Days Between Dates
=NETWORKDAYS(A2,B2)
=NETWORKDAYS(A2,B2,Holidays!A:A)
=NETWORKDAYS.INTL(A2,B2,"0000011")Weekend codes in NETWORKDAYS.INTL let you treat Fri–Sat as weekend, etc.
Tips
- Holidays must be real date values, not text
- If results look wrong, check date serials