I have a column of Filed dates and need to count how many fall within a given year.

Chuckrugger

I've tried several examples that I've come across here but most of them just give a formula without explaining what the components are so I'm having trouble adapting it to my purposes.

Paul Newcome

You would use something like this:

=COUNTIFS([Date Column Name]:[Date Column Name], IFERROR(YEAR(@cell), 0) = 2022)

Just change the 2022 to whichever year you are wanting to count for.

Chuckrugger

Meant to include, the data type for the column is set to Date.

Paul Newcome

You would use something like this:

=COUNTIFS([Date Column Name]:[Date Column Name], IFERROR(YEAR(@cell), 0) = 2022)

Just change the 2022 to whichever year you are wanting to count for.

Chuckrugger

Thanks very much.

Paul Newcome

Happy to help. 👍️