Highlight Upcoming Birthdays with Conditional Formatting

Hello. This is more complex than I thought it would be. I have columns with employee names, Start Dates, and Dates of Birth.

I want to use conditional formatting to highlight Start Date and/or DOB if a birthday or anniversary will occur within 14 days from today.

That is my core need. But if you meet that challenge with ease, I'd love to extend it further by creating a separate "quick glance" worksheet that lists only names that meet one or both of those qualifications followed by "Birthday mm/dd/yyy" and/or Anniversary mm/dd/yyyy.

Capture.PNG

You are welcome to add your own creativity or insights to the display of these if you'd like. In actual practice, this worksheet is part of a workbook with many worksheets in which I store a wide range of employee data, so this will prevent me from poking around in it each day.

Thanks a bunch,

~N

I apologize if I've done this more than once, but here's the attachment. It is not reassuring me that my attachment is going to be transmitted as clearly as I would like.

~N

Thank you protonLeah. I've attached what I created. It almost works.

Today is 7/19/2018.

Kris Kringle's Start Date in C2 is 7/19/2017. It should be highlighted but it is not. Brenda Boyer's birthday is 7/19/1952. It is correctly highlighted. What did I do wrong?

Additional Question:
Can the formula be modified to incorporate Today() rather than me creating a separate column for it?

~N

Thanks. I'll give it a shot.Maybe I misunderstood when you told me for the original solution to put today's date in A1. Doing so meant shifting everything to the right.

Hrmmm... Still not working as I expected.

Can I restart here? I wasn't clear enough in the beginning, I think.

1. The attached is a good representation of my actual spreadsheet
2. I need a Conditional Format formula that highlights birthdays and work anniversaries that are either today or within 2 weeks from today. For example, today is 07/19/2018, so I want to highlight birthdays and work anniversaries that are 07/19/2018 through 08/0282018 (which is 07/19/2018+14 days)
3. I do not want today's date in a cell. I prefer to incorporate Today() into the formula.

If you do this today, while it is still July 19, then in my attached sample B2, B5, and C3, should highlight

I really appreciate the help and hope I've made this clearer.

Thank you!

~N

Perfect. Thank you!