asked on

Correct formula for dates older than 2 weeks problem

I'm trying to highlight dates that are older than 2 weeks in certain tables for column C. These are the exact cell ranges I need C48:C73,C123:C137,C173:C186. But also I dont want blank spaces highlighted. This is the formula I've been trying to make work: =c47>=today()+14, but I just can't figure out why it's not highlighting the dates correctly. Some that are outdated are highlighted but not all.

Naresh Patel

try this ABS(C47-TODAY())>=TODAY()+14

Kaitie Lopes

ASKER

I'm sorry I copied the formula with the wrong column. I need it to be in C, so I tried this =Today()-c47>=today()+14. But it didnt like that either.

Naresh Patel

See my edited comment or share me a sample file.

ozo

depending on the format of c47
c47 < today()-14

Kaitie Lopes

ASKER

Alright I will try that. Thank you. Also just to clarify im going under conditional formatting > new rule > Use a formula to determine... that is correct right?

Naresh Patel

to overcome with blank spaces highlighted you need to add one more condition in Formula, like IF(C47<>"",ABS(C47-TODAY())>=TODAY()+14 ,"")

Kaitie Lopes

ASKER

Alright, so its highlighting. Notice how for some reason 3/1/2018 is highlighted but that was yesterday? That's the problem I keep having.

Naresh Patel

please share the sample file.

Kaitie Lopes

ASKER

Sorry it didnt upload for some reason.
excel-help.PNG

ASKER CERTIFIED SOLUTION