NETWORKDAYS
Returns the number of whole workdays between two dates.
Date & TimeDates & Time Calculations
What it does
Calculates working days excluding weekends (Sat/Sun) and optional holidays.
Syntax
NETWORKDAYS(start_date, end_date, [holidays])
Arguments
start_date(date) — Start date.end_date(date) — End date.holidays(range) — List of holiday dates.
Examples
Count Workdays
Workdays in Jan 2023.
FORMULA
=NETWORKDAYS(A2, B2)
RESULT
22
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 2023-01-01 | 2023-01-31 |