Filter for Decade Birthdays
 

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

Filter for Decade Birthdays
 

Amy,

If your birthdates are in column B starting in row 2, in cell C2 use this formula

=RIGHT(YEAR(B2),1)="7"

and copy down to match your birthday data. Then filter for TRUE on column C.

HTH,
Bernie
MS Excel MVP


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

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

Filter for Decade Birthdays
 

Thanks so much for such a quick reply!!!!! Both of them worked perfectly.

Amy

"bj" wrote:

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