Ooops! Sorry, I'm a bit under the weather today and can't seem to think
straight!

I interpreted your post to mean you had just the 2 dates, a start date and
then an end date.

Ok, let's assume your dates are in the range A1:A100.

=SUMPRODUCT(--(TEXT(A1:A100,"mmm/yy")="Nov/07"))


--
Biff
Microsoft Excel MVP


"tonyalt3" wrote in message
...
On Apr 16, 4:39 pm, "T. Valko" wrote:
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- Hide quoted
text -

- Show quoted text -

What if all dates are in Column A?