Try this:

C1 = 5/12/2008
D1 = 5/25/2008

=COUNTIF(A1:A5,"="&C1)-COUNTIF(A1:A5,""&D1)

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


"Dano" wrote in message
...
Hello,
This is probly a simple thing to do but I cant figure it out . . .
I have a coulumn that is full of dates and I want to count how many cells
fall within a certain range of dates. For example :
A1 = 5/1/08
A2 = 5/5/08
A3 = 5/12/08
A4 = 5/14/08
A5 = 5/25/08
I want to how many cells in this range are earlier than or equal to
5/25/08
but later than or equal to 5/12/08. Should be 3 but what would the
formula
look like to calculate that?

Thanks!