How about
=SUMPRODUCT(--(TEXT(H10:DC10,"m")=MONTH(C4)))
or
=SUMPRODUCT(--(TEXT(H10:DC10,"myyyy")=text(C4,"myyyy")))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ken" wrote in message
...
Bernard ... (Hi)

This formula works ... However, like "Ts" solution when I roll into 2010 I
am going to have a problem ... If it helps ... I could key off of Cell D4
which contains a date occurring in May (or whatever current month is ... I
enter this date each month).

Thanks ... Kha

"Bernard Liengme" wrote:

Following from Biff's great idea:
=SUMPRODUCT(--(TEXT(H10:DC10,"myyyy")=MONTH(TODAY())&"2009"))
This is give you the count for the CURRENT month
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ken" wrote in message
...
Excel2003 ... Range H10:DC10 contains a Formula which returns ... TEXT,
DATEs
& SPACEs ("") ... Range Format = Dates 3/14

I want formula in Cell E135 to return number of DATEs occurring THIS
Month
only (exclude: TEXT, DATES (not this month), & SPACEs).

Thanks ... Kha