Count business days (excluding weekends) between two dates.
Copy this formula
=NETWORKDAYS(A2, B2)NETWORKDAYS counts whole working days from start to end, automatically skipping Saturdays and Sundays. Pass an optional holiday range as the third argument to skip those too.
=NETWORKDAYS(A2, B2, Holidays)→2121 working days, excluding weekends and listed holidays.
=NETWORKDAYS(DATE(2026,3,2), DATE(2026,3,13))→10Two full working weeks, from Monday 2 March to Friday 13 March 2026.
=NETWORKDAYS(DATE(2026,3,2), DATE(2026,3,13))-1→9Subtracting 1 leaves out the start date, giving working days elapsed.
Custom weekend
=NETWORKDAYS.INTL(A2, B2, 11)Code 11 treats only Sunday as the weekend.
Use WORKDAY: =WORKDAY(A2, 10, Holidays) returns the date 10 business days after A2.
Yes, both are counted when they are working days. Subtract 1 if you want the number of days elapsed.
Use =NETWORKDAYS.INTL(A2, B2, 7). Weekend code 7 means Friday and Saturday.
One of the dates is stored as text. Convert it with DATEVALUE or re-enter it as a real date.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.