=SUMPRODUCT(--(TEXT(A1:A100,"mmmyy")="Jan07"))


"Clay" wrote:

Lets assume I have all my dates in one column (T). How can I count the
number of occurances I have per month. I want a count of all dates in Jan,
Feb, etc. for that year.

My data will be setup like this:
A B C
D
1/01/2006 2/01/2006..... 1/01/2007 2/01/2007....
1 Count of Date