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.
You can make short work of this task by unpivoting the registration columns and then creating a pivot table.
Unpivot columns - Power Query | Microsoft Learn
The unpivoting will arrange your data vertically so it's easy to pivot:
- Issue here is that there's also other info listed on the sheet. However I think I maybe can get it work by creating a new sheet and transfer info required for A-C
