I
Iona
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
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