Highlight Date in one cell 14 days after date in another whilst leaving Empties blank

[Mista_sav]

Hi im having trouble. Ive used a few formulas but the best i could get was it would highlight the cell (AB) if the date was greater than 14 days (AA) BUT it also highlighted all the blanks as well which isnt ideal.

The formula i used was

=AND(AA3<=(TODAY()-14),AB3="")

Any ideas to only highlight the cells where there is a date input in AA?

 

[Cubist]

Try

=AND((TODAY() - AA3)>= 14,AA3<>"")

 

[Mista_sav]

Try

=AND((TODAY() - AA3)>= 14,AA3<>"")

Thank you so much! champion!

 

[Mista_sav]

is it possible that if there is a date input that is LESS than the 14 days it wont highlight red?

 

[Cubist]

Try remove the equal sign

=AND((TODAY() - AA3)> 14,AA3<>"")

 

[Mista_sav]

Try remove the equal sign

=AND((TODAY() - AA3)> 14,AA3<>"")

so would it look like this??

=AND((TODAY() - AA3)> 14,AA3<>"")

 

[Mista_sav]

Try remove the equal sign

=AND((TODAY() - AA3)> 14,AA3<>"")

nah didnt work sorry mate,

 

[Cubist]

is it possible that if there is a date input that is LESS than the 14 days it wont highlight red?

Maybe I didn't understand this statement.
Less than 14 days from Today?
OR
Today -14 days, and anything less than this day?

Would be helpful to show some examples.

 

[Mista_sav]

so if AA greater than 14 days AND AB is blank (No date input) then highlight AB. Sorry i should have specified. If they put a date in column AB then it doesnt need to highlight.

 

[Cubist]

I guess the only other alternative is this.

=AND((TODAY() - 14)> AA3,AA3<>"")