Excel: Calculate the frequency of a particular month in a column of date cells

Question

I have a column with dates of events. ( let's say: A1:A100 )

Now I want to use a formula to find or display the number of events that occurred in January 2013.

Any ideas ?

Answer 1

What you need is an array formula, sometimes called "CSE" formulas because of the way you have to enter them:

Pick your destination cell and select it. Then, in the formula bar, enter:

=SUM(IF((A1:A100>=DATEVALUE("1/1/2013"))*(A1:A100<=DATEVALUE("31/1/2013")),1,0))

And instead of [enter], press [ctrl]+[shift]+[enter]

I really don't understand why MS make you do the CSE thing- surely it's clear from the format that it's an array formula?