COUNTIF year is current

Mary Davis

Can anyone tell me what is wrong with this formula for counting rows containing the current year?

=COUNTIF([Date Completed]:[Date Completed], YEAR(@cell) = YEAR(TODAY()))

Paul Newcome

Ok. It may be that you have blanks or non-date values within the column. Lets try an IFERROR...

=COUNTIF([Date Completed]:[Date Completed], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Mary Davis

There were some blanks and that fixed it. Thank you!

Paul Newcome

It looks ok to me. Are you getting an error or an incorrect count?

Mary Davis

Getting #INVALID DATA TYPE error in the Sheet Summary, but Date Completed is a date field.

Paul Newcome

Ok. It may be that you have blanks or non-date values within the column. Lets try an IFERROR...

=COUNTIF([Date Completed]:[Date Completed], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Mary Davis

There were some blanks and that fixed it. Thank you!

Paul Newcome

Happy to help. 👍️