I have a column of Filed dates and need to count how many fall within a given year.
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.
Tags:
Best Answer

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.
Answers

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

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.

Thanks very much.

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!