Count working days between two dates
Count only the business days between two dates, skipping weekends.
The formula
=NETWORKDAYS(A2, B2)How it works
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-06-01 |
| 3 | 2026-06-30 |
Count
22
Counts only the working days (Mon-Fri) between the two dates (22).