One way...

A1 = 9/1/2007
B1 = 3/31/2008

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A1&":"&B1)),"mmm/yy")="Nov/07"))

--
Biff
Microsoft Excel MVP


"tonyalt3" wrote in message
...
I have a list of dates ranging from 9/1/2007 to 3/31/2008. I'd like
to create a function that would count for each month, is that
possible? Example, count only those dates in November 2007