Calculate Workdays Between Dates

Count business days with NETWORKDAYS, excluding weekends and holidays.

You will learn to

• Exclude weekends
• Exclude a holiday list

How it works

NETWORKDAYS(start, end, [holidays]) counts weekdays between two dates inclusive, skipping Saturdays, Sundays and any holiday dates you supply.

=NETWORKDAYS(B2,C2,E2)