COUNTIF Only if System Generated Date Column is Current Year
I am trying to create a formula in a Sheet Summary field that displays the total number of rows I have in the sheet that were created in the CURRENT YEAR. I have a system-generated date column - the column is titled "Created".
The only criteria is that the Created column has a date and that the date is in the current year.
I cannot figure out how to use a COUNTIF formula to display only the number of rows that have a date in the current year. I've looked through the discussions and have seen different variations, but none of them work.
The system-generated date column has a xx/xx/xx format for the month/day/year - so I wonder if that has something to do with it? I've been trying to use YEAR or DATE in my formulas, but they all seem to want a 4 digit year.
This seems like it would be simple - just count the current year. I'm hoping there is a simple solution that I'm just missing.