Forum Discussion
Count the number of dates that fall within a certain month
Hi, I'm looking for a formula that counts the number of dates in a list fall within a certain month. If at all possible without intermediate steps. To be more specific, I'm wondering if there's...
In general that could be
=SUMPRODUCT( ( IFERROR( N(MONTH($B$2:$D$7)), 0) = MONTH($F2) ) * ( IFERROR( N(YEAR($B$2:$D$7)), 0) = YEAR($F2) )* ISODD( ROW($B$2:$D$7) ) )by adding one more criteria. Details depends on content, do you mean odd row within the grid, or odd row counting from the start of the range.
In general that could be
=SUMPRODUCT(
( IFERROR( N(MONTH($B$2:$D$7)), 0) = MONTH($F2) ) *
( IFERROR( N(YEAR($B$2:$D$7)), 0) = YEAR($F2) )*
ISODD( ROW($B$2:$D$7) )
)by adding one more criteria. Details depends on content, do you mean odd row within the grid, or odd row counting from the start of the range.
Wondering if it's possible to add an additional criterion. Like in below example calculate how many registrations in a certain month but only for new students (so only for those indicated with "Yes" in column C). Or in other words, an automated count in the cells in yellow.
