COUNTIF date formula
 

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

COUNTIF date formula
 

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)

"suek" wrote in message
...
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

COUNTIF date formula
 

It works splendiferously! Thanks!

"Ron Coderre" wrote:

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)

"suek" wrote in message
...
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

COUNTIF date formula
 

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

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

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

"suek" wrote in message
...
It works splendiferously! Thanks!

"Ron Coderre" wrote:

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)

"suek" wrote in message
...
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