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?

 

[Mista_sav]

I guess the only other alternative is this.

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

ok cool. Yeah still highlights when i put a date in AB. All g mate though still works well

 

[Cubist]

I think you want to compare the date difference in AA and AB? If the difference is 14 days then highlight? If so I'm not sure why the need for TODAY()?

 

[Mista_sav]

I think you want to compare the date difference in AA and AB? If the difference is 14 days then highlight? If so I'm not sure why the need for TODAY()?

yeah basically what i need is that when they put the date in AA they need to contact the member within 14 days. If they dont then the cell AB will highlight to prompt them to call. once the put a date in AB that means they have made the call, it wont need to highlight

 

[Cubist]

I think I understand what you want re-reading the thread. Try

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

 

[Mista_sav]

I think I understand what you want re-reading the thread. Try

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

that worked BUT it re highlighted the blanks hahah

 

[Cubist]

Ok, How about this? Left out the blanks when testing.

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

 

[Mista_sav]

Ok, How about this? Left out the blanks when testing.

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

Perfect. Thank you heaps!!! Much appreciated!