count cells in time period
Posted by Joe on July 26, 2001 2:30 PM
Hi, I have a list of cells with different dates. I would like to count the number of cells within each month. Is there an easy way to do this?
Posted by Aladin Akyurek on July 26, 2001 2:48 PM
lets say that your dates in A from A2 on (e.g., A2:A100).
Enter the numbers 1..12 (for months) say in C from C2 on.
In D2 enter: =SUMPRODUCT((MONTH($A$2:$A$100)=C2)+0)
Copy down this as far as needed.
Aladin
