One way:

=COUNTIF(K3:K78,"="&DATE(2008,7,1))-COUNTIF(K3:K78,""&DATE(2008,7,31))

Or, use cells to hold the date boundaries:

A1 = 7/1/2008
B1 = 7/31/2008

=COUNTIF(K3:K78,"="&A1)-COUNTIF(K3:K78,""&B1)

--
Biff
Microsoft Excel MVP


"Iona" wrote in message
...
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