Hi!

One way:

=COUNTIF(A:A,"=7/1/2006")-COUNTIF(A:A,"7/31/2006")

Better to use cells to hold the criteria:

B1 = 7/1/2006
C1 = 7/31/2006

=COUNTIF(A:A,"="&B1)-COUNTIF(A:A,""&C1)

Format the cell as GENERAL

Biff

"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