LOL! Understood and fair enough. I appreciate your help!

I have another formula I am trying to convert from 2007 to 2003. Do you
think you could help me "again". I tried the same format and it didn't work.
Not sure if it is because it is in a seperate sheet, but same workbook? Here
is the formula from 2007. And I am doing the same thing. Counting a date
range for one column of cells. This should be basic for me but am having
difficulty. Total User Error.

=COUNTIFS('Site_Customer Log'!Q5:Q120,"<=08/31/08",'Site_Customer
Log'!Q5:Q120,"=08/01/08")

"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