countifs formula to sum not blank dates
Hello ~ I'm new to the community and working with the COUNTIFS formula. Help would be much appreciated if you can see the error of my ways. What I want to do seems simple - I have a "Date Completed" column, defined as a Date type, and want to count how many times it's been entered in the column. I saw a thread earlier that addressed a similar topic, but I've so far been unable to get it to work. Here's the formula I'm working with:
=COUNTIFS([Date Completed]:[Date Completed], IFERROR(YEAR(@cell), 0) >= 2019)
I'd like it to be more generic, using a not isempty, but so far haven't been able to get it to work. The formula is expecting a #DATE EXPECTED (presumably since the column is a Date type) - is there a way to do this?