Date & Time
Business Days Between Dates (NETWORKDAYS)
Calculate the number of business days (working days) between two dates, automatically excluding weekends. Optionally exclude holidays too.
Excel Formula
=NETWORKDAYS(A2, B2)Step-by-Step Explanation
1
NETWORKDAYS counts working days between two dates
2
A2 is the start date
3
B2 is the end date
4
Automatically excludes Saturdays and Sundays
5
Add a third argument for holidays: =NETWORKDAYS(A2,B2,C2:C10)
Example
| Start Date (A) | End Date (B) | Business Days (C) |
|---|---|---|
| 1/1/2026 | 1/31/2026 | 22 |
| 3/1/2026 | 3/15/2026 | 10 |
Result: Formula in C2: =NETWORKDAYS(A2,B2) → 22
Common Variations
With holidays
=NETWORKDAYS(A2,B2,D2:D10)Exclude specific holiday dates
Custom weekends
=NETWORKDAYS.INTL(A2,B2,11)11 = Sunday only weekend
Add business days
=WORKDAY(A2,B2)Find date N business days from start
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →