The result is an array of TRUE FALSE values, where TRUE represents dates in the month of interest.
TheN functionis used tochange these values to ones and zeros, and SUMPRODUCT simply sums and returns the array.
The N function can be used to convert TRUE and FALSE to 1 and 0 respectively.
When given a text value, the N function returns zero.
