How many days are there excluding X days?

An Excel file that teaches how to perform How many days are there excluding X days? operation.

Excel Format: How Many Days Are There Excluding X Days?

Start and end dates are entered. Exclusion days are listed in a separate table. Out-of-scope days are eliminated with array formulas. The result is reported as the net number of days. The flexible structure is adapted to different scenarios.

Hope it is useful.