Count if rows contains specific year

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
Hello,
I need to count how many rows contains a date with a specific year, but with the following doesn't work:
=COUNT.IF(D3:D3394;"*2014")
I changed also the format of the date into day month year, and tried with different formulas, but nothing, it's not coming out correct.

Thanks,in advance,
Luke

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Luke, Good morning.

Try to use:
=SUMPRODUCT((YEAR(D3:D3394)=2014)*1)

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão