View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dvinechild Dvinechild is offline
external usenet poster
 
Posts: 17
Default Count Date Entries Per Quarter

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.