And to avoid the 2005, 2004, 2003, ... dates

=sumproduct(--(text(c2:c5,"yyyymm")="200607"))


Don Guillett wrote:

how about
=SUMPRODUCT((MONTH(C2:C5)=7)*1)
--
Don Guillett
SalesAid Software

"Dewayne" wrote in message
...
Is there a way to count only the cells that fall within a defined date
range?
Example:
Count only the number of cells in a range that fall within the date range
of
7/01/06 through 7/31/o6.
Thanks for any help
--
Dewayne

--

Dave Peterson