Counting Dates
Both Don and Ron's solutions worked. Thanks for your help
"Ron Coderre" wrote:
Try something like this:
=SUMPRODUCT(--(TEXT(A2:A100,"yyyymm")="200701"))
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"MikeG" wrote in message
...
I would like to count the numbers of entris in a column that have the same
month and year. Each value has a date defined as mm/dd/yyyy.
Ex. how many entries are there for January 2007?
do I use countif?
|