New user here... Need formula on how to count how many entries in a column are in a specific month

J_Lukeeee

Hey there,

I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc.

So far I have tried the following.. Please let me know how I should adjust:

=COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell <=DATE(2024, 1, 31), {Checkbox Range}, @cell =1) = #UNPARSEABLE

=COUNTIF({Range 1} = "01") = #INCORRECT ARGUMENT SET

=COUNTIF(MONTH(1){ Range 1} = #UNPARSEABLE

=COUNT(MONTH(1), {Range 1}) = 13 BUT THERE ARE ONLY 7 IN THE MONTH OF JAN

=COUNTIF({Range 1}, CONTAINS(1, {Date of Destruction})) = 0 BUT THERE ARE 7 IN THE MONTH OF JAN

Any help is appreciated.

Signed,

New to smartsheets :(

Lucas Rayala

@J_Lukeeee

=COUNT(COLLECT({Target Date Column}, {Target Date Column}, MONTH(@cell)=1))