You will have to remove the headers and other text data to use this formula.
or other wise this will return an error...

If this post helps click Yes
---------------
Jacob Skaria


"Dilly" wrote:

Is it possible to utilise this formula, however, by just highlighting the
column column as the range, as opposed to physically highlighting from
A1-A1000. If i use this folrmula and highlight column A as opposed to
A1:A1000 i get a NUM error

Thanks in advance

Mark

"Jacob Skaria" wrote:

Missed out the year

=SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2009))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Suppose you have dates in ColA, number of dates in February is .

=SUMPRODUCT(--(MONTH(A1:A1000)=2))

If this post helps click Yes
---------------
Jacob Skaria


"Dilly" wrote:

Could somebody please assist with a formula to count the number of dates in
February 2009 for example, from a "long" list of random dates.
We have a helpdesk function that logs calls and am trying to establish how
many calls we received in February 2009