Count business days between a start date in A2 and an end date in B2, excluding holidays in H2:H20

公式

=NETWORKDAYS(A2, B2, H2:H20)

说明

NETWORKDAYS counts Mondays–Fridays between two dates, inclusive, and subtracts any holiday dates you pass in the third argument.

步骤

  1. A2 is start, B2 is end.
  2. Holidays live in H2:H20 as real dates.
  3. The result includes both the start and end if they are workdays.

变体

Custom weekend (Fri–Sat)

Weekend code 7 = Friday and Saturday. See Excel help for other codes.

=NETWORKDAYS.INTL(A2, B2, 7, H2:H20)

Add 10 working days

Returns the date 10 business days after A2.

=WORKDAY(A2, 10, H2:H20)

Exclude start date (open interval)

Use when you need whole days after kickoff.

=NETWORKDAYS(A2, B2, H2:H20)-1