COUNTIF date formula

S

suek

Hello,
I have a column of dates in dd/mm/yyyy format, and I need to add up the
total number of instances in a given month. I have been trying to use a
COUNTIF (P:p, (DATE mm = "01")) formula, and a million and one other
configurations of this, and cannot get it to work, does anyone have any
suggestions?

Thanks
 
R

Ron Coderre

Try something like this:

=SUMPRODUCT(--(TEXT(A1:A50,"yyyymm")="200801"))


Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
S

suek

It works splendiferously! Thanks!

Ron Coderre said:
Try something like this:

=SUMPRODUCT(--(TEXT(A1:A50,"yyyymm")="200801"))


Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
R

Ron Coderre

You're very welcome......I'm glad I could help.

--------------------------
Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Top