Sheet reference Countifs formula with a date

Ryan P Anderson

Hello,

I have a column that's a date and need a formula on a separate sheet to count if the date is current year. I haven't been able to find any community posts about sheet references, only cross sheet ones.

Current formula: =COUNTIF({Date Column}, ISDATE(>2023)). I get an invalid ref error.

Nic Larsen

@Ryan P Anderson

Try:

=COUNTIF({Date Column}, IFERROR(YEAR(@cell), 0) = 2023)