View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default Counting number of incidents of a month

What is an occurrence - a date in your DATE range or something else?

CD Web wrote:
I have a spreadsheet that has one named range 'DATE' which contains a date
in the format 01-MAR-05.

I have a summary sheet that I have each month listed in 12 cells (Jan to
Dec).
I want to read the DATE range, and count the number of occurances which fall
into each month.

Is this possible with a Excel funtion, or mixture of functions, or do I need
to write my own?

Thanks for any help.

Regards

Chris Darlington