WWorkTools
Excel

How to Count Working Days in Excel

Use NETWORKDAYS and WORKDAY concepts for weekday planning and holiday ranges.

Published 9/3/2026

How to Count Working Days in Excel

=NETWORKDAYS(start_date,end_date) counts weekdays inclusively. Add a holiday range with =NETWORKDAYS(A2,B2,H2:H10). =WORKDAY(start_date,days) returns a future or past weekday date. Weekend conventions and holiday calendars should match your workbook. Compare with the working days calculator.

Use the related calculator
Working Days Calculator →

Related guides

Absenteeism Rate Formula: How to Calculate Employee Absence Rate →How to Calculate PTO Accrual: Hourly, Biweekly and Monthly Examples →How to Count Working Days Between Two Dates →