Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:


share|improve this question

It looks like you have the right idea but the formula needs a little tweaking.

Try this:


Some things to point out: - For a MM/DD/YYYY format, you need to take the right character, not left - The cell contents for dates are not strings, so you need to use TEXT() to convert the dates

This worked on my test sheet, let me know if it works for you or if I need to tweak it a bit.

share|improve this answer

In addition to the solution provided by OnenOnlyWalter, here's another formula:


The YEAR function simply returns the year in 4 digits. The ARRAYFORMULA will just take on the complete column and the COUNTIF will finish it off by counting the occurrences.

If you're using a header, then you can adjust the above formula like this:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.