Number of Dates in a Column

I'm looking for a simple formula to count dates contained with a month and year.

The date format is set up as such: 01/11/2023

I've read plenty of advice on this one but I cant find any entry with a clear answer to this question.

Currently I'm at

=COUNTIFS({START DATE}, Date:Date, MONTH(@cell) = 11, Date:Date, YEAR(@cell) = 2022)

Am I close or no where near? Any help would be much appreicated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!