View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
R.VENKATARAMAN
 
Posts: n/a
Default Counting Rows by Month

there may be easier ways
what I would do
your first date is A1
in B1 type
=month(a1)
copy down all the 2500rows in column B
if you want to count for the month of November which is 11
empty cell type

=COUNTIF(B1:B2000,11)

===============================
"Paul S" wrote in message
...

Wrote:
Hi,

I have a large table with ~2500 rows. One column contains date
information (date of the creation of the record).

I'd like to count how many records (rows) I have for each month. I
tried with the countif() function, but I don't know how to express a
date range in the criteria field.

Thanks in advance for your help.

Raph


Hi Raph

Try adding a helper column into which you paste the dates, then format
the dates as mmm, and then do countif


--
Paul S