Dates & Time

Excel formula for Count working days between dates

Count business days (excluding weekends) between two dates.

Copy this formula

=NETWORKDAYS(A2, B2)

How the formula works

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.

Examples

=NETWORKDAYS(A2, B2, Holidays)→21

21 working days, excluding weekends and listed holidays.

Other ways to do this

Custom weekend

=NETWORKDAYS.INTL(A2, B2, 11)

Code 11 treats only Sunday as the weekend.

FAQ

How do I get a future date that's N working days away?

Use WORKDAY: =WORKDAY(A2, 10, Holidays) returns the date 10 business days after A2.

Related formulas

Days between two dates Add or subtract months from a date

Functions used

NETWORKDAYS WORKDAY

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.

Try ExcelGPT free