I have a very long list of people with there birthdays (date, month, year). I would like to:
1. Count how many people in the list were born on specific day (birthday- only day and month-no year) in order to send irthday greeting cards (need only number of people)
2. Is possible along with bithday dates to extract the name of the people- actually creating a new list of people born on this day.
I would like to sove these points with formulas
I tried to solve the problem with pivot table but without success.
Thanks in advance for the help
Bookmarks