Counting data for month and year

A

ahkasiv

I've looked at the multiple threads and can't seem to figure out how to count
the number of cells that have values within a date range. For example, how
many cells in A2:A76 have a value within July 08? I have found how to do it
for the month but how about the year?
 
G

Gary''s Student

=COUNTIF(A2:A76,"<"&DATEVALUE("8/1/2008"))-COUNTIF(A2:A76,"<"&DATEVALUE("7/1/2008"))
 
A

ahkasiv

Thanks! I made one slight change--< to > in <"&DATEVALUE("7/1/2008").

Any idea how I can autofill this formula without too much maintenance.

Thanks again!
 
D

David Biddulph

Well, you're entitled to make that change if you like, as it was your
question, but perhaps you could explain the logic of your revised formula?
You may also wish to recheck the test results for your revised version, as
Gary''s Student's formula looks to be the correct answer.
 
Top