Count how many persons in a month using a date

M

mash

I want to know what a formula to count how many person in my list in a month
using registration date. As example : 18-Jan-07, 31-Jan-07 and 7-Feb-07. The
result is 2 person in Jan and a person in Feb.
 
B

Bernard Liengme

With dates in A1:A3
=SUMPRODUCT(--(MONTH(A1:A3)=1))
for Jan
=SUMPRODUCT(--(MONTH(A1:A3)=2))
for Feb
etc
best wishes
 
Top