Thank you. I was close. It seems to work. Please advise what the &
performs in the foprmula so I can better understand.

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.