Counting Dates
for january =COUNT(IF(MONTH($A$1:$H$1)=1,$A$1:$H$1))
press CTRL+SHIFT+ENTER not only ENTER
For feb change 1 to 2 in the formula and so on...change the range as per
your need.
hope this helps.
"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?
|