Hi All,

I have a column "A" of dates in the typical xx/xx/xxxx format. Then I have column "B" of years in the xxxx format.

I want to apply a countif formula in column "C" that counts up all the occurrences in column A that matches the year in column B.

For example:

column A has: 05/01/2013, 8/01/2013, 12/12/2013, 1/01/2014, 1/03/2014
column B has: 2013
Column C (the countif formula) has: 3 (counted all the 2013 occurrences in column A)

How do I write that countif formula? Thank You,