Count Date Entries Per Quarter
Try this:
Use cells to hold your date boundaries:
C1 = start date
D1 = end date
=COUNTIF(A1:A100,"="&C1)-COUNTIF(A1:A100,""&D1)
--
Biff
Microsoft Excel MVP
"Dvinechild" wrote in message
...
Hola fellow Excel Kings & Queens~
Please let me know if there is a way to do the following:
Count the number of entries per quarter of data listed in a column.
I've thought about setting a < of entries falling between set date
criteria, but unsure how to do this. Column is currently formatted in
mm-dd-yy. I don't understand enough about converting date info so that I
might get the infor I'm after, but I have a hunch that I might have to go
down that road. :-)
Equation can be seperated into 4 seperate equations to keep things
simplified, the data is just ongoing and the results get put into
graphs/charts.
Your help is appreciated.
|