Filter for Decade Birthdays
try a helper column
=mod(year(birthday),10)
then use auto filter for 7 (for this year)
"Amy" wrote:
I have a list of Clients with birthdays, but only want to send gifts to
clients with decade birthdays this year, (40, 50, 60 etc). I am not sure how
to "pull out" the people with the right year of birth from the entire list.
Thanks in advance!
Amy
|