Forum Discussion
Solved
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.
Thanks, could make it all work!
Great to know, thank you for the feedback