COUNTIF date formula

  • Thread starter Thread starter suek
  • Start date Start date
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
 
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)
 
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...
 
You're very welcome......I'm glad I could help.

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

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