| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you format each pie chart segment with different fills | Charts and Charting in Excel | |||
| Each client to be identified into segment | Excel Discussion (Misc queries) | |||
| How to add trendline over multiple series and a segment of x-value | Charts and Charting in Excel | |||
| How to delete a line segment? | Charts and Charting in Excel | |||
| Setting a pie chart segment to No Fill | Excel Discussion (Misc queries) | |||
Linear Mode
