Counting data for month and year
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.
--
David Biddulph
"ahkasiv" wrote in message
...
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!
"Gary''s Student" wrote:
=COUNTIF(A2:A76,"<"&DATEVALUE("8/1/2008"))-COUNTIF(A2:A76,"<"&DATEVALUE("7/1/2008"))
--
Gary''s Student - gsnu200798
|