Excel (if statement, maybe?) Birthday List

Hello I am trying to use a simple excel sheet (last name, first name, date of birth, date of hire) for an employee listing to then create a list of birthdays (probably +/- 7 days) - just the last & first name. Secondly the same thing for the hire date (probably +/- 14 days) and the years of service, that calculation I figured out easily,

I was trying to do this with if statements or datedif and am struggling.

maybe this isnt the proper tool, any thoughts, suggestions would be greatly appreciated!

Thank you