google sheets – How Can I Exclude Vacation Weeks From A Week Number Count?

See testSheet

You can put Week count start date in cell B1.
Then you can specify vacation start and end.

Idea is to calculate weeks omitting vacations.

For that purpose we use NETWORKDAYS.INTL() formula and since it will return working days we wrap it with QUOTIENT() formula with divisor of 5.

NETWORKDAYS.INTL counts days between dates and excludes holidays, so here comes vacation start and end.

We use SEQUENCE() formula to generate dates based on vacation start and end.
You may add more vacations adding start and end dates and adding SEQUENCE() formula to array {}.

=QUOTIENT(
 NETWORKDAYS.INTL(
  $B$1,
  TODAY(),
  1,
  {
   SEQUENCE($B$3-$B$2+1,1,$B$2,1);
   SEQUENCE($B$5-$B$4+1,1,$B$4,1)
  }
  ),
 5)+1