NETWORKDAYS
Date & timeExcel 2007Count working days between two dates, skipping weekends and holidays.
Syntax
NETWORKDAYS(start_date, end_date, [holidays])
Arguments
- start_date
- First day (counted).
- end_date
- Last day (counted).
- holidaysoptional
- A range of dates to also exclude.
Examples
=NETWORKDAYS(A2, B2, Holidays)
→ billable days
Good to know
- NETWORKDAYS.INTL lets you define which days are the weekend.
Related functions
More Date & time functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.