Home » Posts

Count holidays between two dates

To count holidays that occur between two dates, you can use the SUMPRODUCT function. In the example shown, the formula in F8 is: =SUMPRODUCT((B4:B12>=F5)*(B4:B12

April 14, 2025 · 1 min · 14 words · Jason Estrada

Table of Contents

Explanation

This formula uses two expressions in a single array inside the SUMPRODUCT function.

Excel formula: List holidays between two dates

Excel formula: Count dates by day of week

Excel SUMPRODUCT function

Explanation#

Explanation