Count working days with NETWORKDAYS
Step 1 of 3
B2-A2 counts every day between two dates. For a project plan you usually want working days, without Saturdays and Sundays.
Click Continue when you're ready.
Already know it? Type the formula straight into C2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Start | End | Working days | |||
| 2 | Mar 4, 2024 | Mar 15, 2024 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
March 4 to 15, 2024 is two full weeks, Monday to Friday. NETWORKDAYS counts the weekdays and includes both the start and the end date, so it gives 10. B2-A2 would give 11, the number of days in between, weekends included.
Common mistake: Subtracting the dates and expecting working days. Subtraction counts weekends and leaves out the start day.
The answer
- C2
=NETWORKDAYS(1A2,2B2)
In plain words: Count the working days from 1the start date in A2 to 2the end date in B2.
=NETWORKDAYS(A2,B2) counts Monday to Friday from A2 to B2, both included. Add a range of holidays as a third argument.
+10 points