Forum Discussion

Bourrinho's avatar
Bourrinho
Copper Contributor
Feb 28, 2024
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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 29, 2024

    Bourrinho 

    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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 28, 2024

Bourrinho 

Easiest way is to create PivotTable. If with formula, in column D do you have texts or dates formatted as mmm/yy ?

Resources