I have a column (A) that contains a series of dates in the format mm/dd/yyyy. I want to run a count to return how many of them were in 2013.
Is this possible? I tried using this formula, but it didn't work:
=COUNTIF (ARRAYFORMULA ( LEFT (C:C, 4)), "2013")