How to Calculate Working Days in Excel
Master NETWORKDAYS and NETWORKDAYS.INTL with custom holiday ranges.
MM/DD/YYYY
MM/DD/YYYY
Total Business Days (Inclusive, Excel NETWORKDAYS)
10 business days
Out of 15 total calendar days · 80 working hours (8h/day)
10 business days 4 weekend days + 1 federal holiday
Excludes: Memorial Day (2026-05-25)
Note: Statutory/public holidays may differ from financial market or banking holidays (e.g., NYSE observes Good Friday). Add custom dates above if needed.
How to Use NETWORKDAYS and NETWORKDAYS.INTL in Excel
Excel's NETWORKDAYS function counts Monday through Friday between two dates (inclusive) and subtracts any holiday dates listed in an optional range:
=NETWORKDAYS(A2, B2, $E$2:$E$12)
For custom weekends (e.g., SundayβThursday workweeks or 6-day workweeks), use NETWORKDAYS.INTL:
=NETWORKDAYS.INTL(A2, B2, "0000110", $E$2:$E$12)