Calculating How Many Days There Are Except for a Specific Day

File teaching Calculating How Many Days There Are Except for a Specific Day operation.

Excel Powered Calculating How Many Days There Are Except for A Specific Day

The BALANCE formula calculates the date difference. The excluded days are defined in the text. The array formula applies filtering. The total number of days is calculated dynamically. The result is printed to the table.

Hope it is useful.