Highlight original date when two weeks are past (14 Day)

[Leicester City Fox]

Hi there

I have a column of dates and I have been asked to do a formulaso when two weeks have passed from the date shown (14 days) it highlights it.

E.g : 01/04/2018 highlight after 15/04/2019 = 14 days past(2 Week)

Many Thanks
Leicester City Fox

 

[Special-K99]

Assume the dates start in A1 (adjust the formula as required).

Select the cells to highlight

Conditional Formatting
New Rule
Use a formula to determine...

=TODAY()>=A1+14

Format as required

 

[tyija1995]

Hey use conditional formatting in the column of dates, I'd personally start with the first cell and do that, lets say your dates are in cells A2 to A25
Select cell A2
Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:

=AND(NOT(ISBLANK($A2)),TODAY()-$A2>=14)

Format -> Select any format you want to apply to these cells -> OK -> OK

Now with cell A2 selected go back in to Conditional Formatting -> Manage Rules -> Change the Applies to range to =$A$2:$A$25

Then you should be done!