6 Months from a date

[SMITRY]

Hello,

Need some help and can't seem to find the answer. I have a column of dates (U4) and I need to have them highlighted when that date reaches 6 months after the date in the cell.

EX. 1/14/2021 - When this date reaches 6 months from 1/14/21 I want it to highlight red. Is this possible?

Thank you all in advance!

 

[Joe4]

Welcome to the Board!

You should be able to use Conditional Formatting for this.
Your Conditional Formatting formula would look something like:

=EDATE(U4,6)<=TODAY()

 

[SMITRY]

Thank you for the fast reply Joe.

Do I have to do this for each date or is there a formula to apply it to each date? I have a whole row of about 90 dates that I need that function to happen to.

 

[Joe4]

No, you can do this all at once.
Select your whole range of dates, and then go to Conditional Formatting and write the formula as it pertains to the very first cell in that selection of dates.
If U4 is the first cell, then you should be able to use my formula, as-is, without having to make any edits.
Excel is smart enough to adjust it for the other cells in your selection.

 

[SMITRY]

Thank you Joe it worked. I appreciate your help!

 

[Joe4]

You are welcome.
Glad I was able to help!