Opss, I forgot one thing - each date in the column can have one of three
tiers (values I, II, or III). How would I expand the formula to do the counts
by date and then by tiers? For example, there could be 3 occurances of
5/1/2009, one occurance woudl have Tier I, and the other two occurances woudl
have Tier II.

Thnak you .

Mark :)

"RagDyer" wrote:

It's best to place your criteria in assigned cells, so that you can revise
the dates without having to change the formula itself.

Start date in B1,
End date in C1,

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

OR, not using entire columns ... except in XL07,

=SUMPRODUCT((A1:A100=B1)*(A1:A100<=C1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"NWO" wrote in message
...
Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.