Skip to main content

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)