Jun 18 2021 02:36 PM
I am attempting to compare a date in a column to January first of each year. I have tried to use the YEAR(date) function.... countif(a2..a15>YEAR(Today())) but it does not work. Anyone have a suggestion?
Jun 18 2021 02:49 PM
@HRGuru55
Perhaps
=COUNTIF(A2:A15,">="&DATE(YEAR(TODAY()),1,1))
or
=SUMPRODUCT(--(YEAR(A2:A15)=YEAR(TODAY())))
