Segment and count birthdays
 

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

Segment and count birthdays
 

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
Microsoft MVP Excel
SalesAid Software

"Michael" wrote in message
...
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

Segment and count birthdays
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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
Microsoft MVP Excel
SalesAid Software

"Michael" wrote in message
...
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