Counting entries in a date range

[kiah522]

I am attempting to create a formula that will count the number of entries that fall in a certain date range under my "Date Submitted" column. In other words, I want to know how many entries I have for July, August, September, etc. My date format is mm/dd/yy. Any ideas? Thanks!

[ChemistB]

For Excel 2007 try

=COUNTIFS($A$3:$A$100,">="&DATEVALUE("1/1/2011"),$A$3:$A$100,"<" & DATEVALUE(" 2/1/2011"))
or you can put your beginning and end date into cells (i.e. B1 and C1) and simplify

=COUNTIFS($A$3:$A$100,">="& B1,$A$3:$A$100,"<=" & C1)
Does that do what you want it to?

[kiah522]

You're awesome! Thanks!