Segment and count birthdays

[Michael]

Hello,
I have been given a list of members to our organisation and each has a full
birthdate attached, we would like to send them all an electronic birthday
card when the time comes around, however so I can get an idea of the workload
I would like to know how many will be sent daily.

Is there a way to count how many people have the same birthdate (day/month)?

many thanks in advance

Michael

 

[Don Guillett]

put the day you want to check for in cell l3 and use this in L4
=SUMPRODUCT((MONTH(K1:K21=MONTH(L3))*(DAY(K1:K21)=DAY(L3))))

 

[Don Guillett]

When I said put the "day" I meant if you want to check for Oct 7 just enter
10/7 and excel will use 10/7/2009