DATEs occurring THIS Month

Assuming THIS month means May 2009...

=SUMPRODUCT(--(TEXT(H10:DC10,"myyyy")="52009"))

Does THIS month mean that as of June 1 the formula should only count dates
for June 2009?

--
Biff
Microsoft Excel MVP


"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