Need excel help

[Blitzkrieg]

I have a range of 980 dates, they are actually real estate closing dates. I want to count the number as they occur each month, by month. In other words, how many closed in Jan, Feb, etc.

Do I use a pivot table?

[Hamhock]

i'd just chop them into 12 lists, then use COUNT

but, I'm lazy like that

[skycat]

Write a VBA script.

YWIA

[Blitzkrieg]

speak english, please.

[mdklatt]

I have a range of 980 dates, they are actually real estate closing dates. I want to count the number as they occur each month, by month. In other words, how many closed in Jan, Feb, etc.

Do I use a pivot table?

COUNTIF(), or a slick combination of IF() and SUM()--ask the paperclip for examples.

[SCOUT]

My excel skills are pretty basic, but I would add a column to the side and use =month(cell reference). Then =countif()

[jkm, the stolen pifwafwi]

countif(month(cell), 1)
countif(month(cell),2)
countif(month(cell),3)

etc...

[Blitzkrieg]

So if my dates are represented as number i.e. 1/05/2005, how then do I do this?

[mdklatt]

So if my dates are represented as number i.e. 1/05/2005, how then do I do this?

Try this:

=countif(month(datevalue(A1)), 1)

etc.