Math & Statisticsintermediate
SUMIFS for monthly revenue by category
=SUMIFS($D:$D,$B:$B,$G$2,$C:$C,">="&DATE(2026,1,1),$C:$C,"<"&DATE(2026,2,1))
Excel how-to guide
How to networkdays project timeline in Excel
Estimate project duration, delivery lead time, or turnaround windows in business days instead of calendar days.
Step-by-step instructions
How to networkdays project timeline — 3 steps
1
Put the project start date in B2 and the end date in C2.
2
Use NETWORKDAYS to count only weekdays between those dates.
3
Add an optional holiday range later if you need to exclude company holidays too.
Example data
Worked example
| Start Date | End Date | Business Days |
|---|---|---|
| 2026-04-01 | 2026-04-10 | 8 |
| 2026-04-06 | 2026-04-17 | 10 |
Common mistakes
Errors to watch out for
Result seems too high
Check that the cells are real dates, not text strings that only look like dates.
FAQ
Frequently asked questions
Can NETWORKDAYS exclude holidays too?
Yes. Add a third argument with a holiday range and Excel will exclude those dates from the count.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides