Bithday conditional

  • Thread starter Thread starter Trippin
  • Start date Start date
T

Trippin

Im trying to get excel to highlight a birthday 10 days before it arrives i
have dates and ages. i greatful for your help thanks
 
If you have birthdates in date format in column C, beginning with row 2,
select range, and Format - Conditional Formatting
Change Cell Value Is: to Formula Is: and enter (copy and paste) this formula
=AND(DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))>=TODAY(),DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))<=TODAY()+10)
Format as desired. Adjust ranges as necessary. Conditional formatting will
begin 10 days before birthday and remain through birthday.

DATE(YEAR(TODAY()),MONTH(C2),DAY(C2)) is converting the birthday in C2 to
the same month and day of this year so that we can make a comparison to
todays date...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Birthday Alert 2
HAPPY BIRTHDAY 1
How do I set up an anniversary to display 10th, 11th, 12th etc? 1
Convert 2-digit year 3
advance number by 1 when compared 2
Happy Birthday @Ian 7
Date Parameter - Desperate for HELP!!!!!!!! 4
Month - Formula Help? 2

Back
Top