Count how many persons in a month using a date

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct but only first time corresponding value is seen e.g. un 1
Date Function 5
Access Count dates within a Month 4
Calculate within a time range with only start date and end date 2
How do I find the month 5
Frequency of date 4
Excel Help with dates 2
Need to transform the dates to months 4

Top