Iona,

The basic idea in counting date ranges is you count everything greater then
and equal to your start date then subtract everything greater than and equal
to your end date. Try this. FWIW I would embed the date in the formula I'd
use a cell reference that contains the date. Note I've changed the date
format to match my machine so change it back to match yours.

=COUNTIF(K3:K78,"=1/9/2008")-COUNTIF(K3:K78,"=1/10/2008")

Mike

"Iona" wrote:

Hello,

I really need help troubleshooting a formula. I am in Excel 2003.
I am trying to count a column that has a different dates within a specific
date range as well as to include the first and end of month dates.
Column Name (Column K) = Start Date
Dates fall under column K as well K3:K78
7/16/08
8/15/08
8/1/08
6/4/08
7/1/08
7/31/08
7/2/08

Here are my formulas that didn't work:
=IF(AND("=07/01/08","<=07/31/08"),COUNT(K3:K78),"")
This formula returns a #Value!

=COUNTIF(K3:K78,"<=07/31/08")+COUNTIF(K3:K78,"=07/01/08")
This formula counts the 7/1/08 and 7/31/08 twice