Filter for Decade Birthdays

[Amy]

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

 

[Bernie Deitrick]

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

 

[bj]

try a helper column
=mod(year(birthday),10)
then use auto filter for 7 (for this year)

 

[Amy]

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

Amy