Hi,

Try this

=sumproduct((range="05/15/2009")*(range="05/21/2009"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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.