Conditional format based on # of days from date entered

[sburkhar]

I'm attempting to have my date turn red if 14 days have passed. I'm failing miserably.

 

[adam087]

You can set up a conditional format to look something like<today()-14<today()-14

=A1 < TODAY()-14

/AJ</today()-14<today()-14

 

[sburkhar]

I thought about that, but I have some dates in there from April. I want the date to turn red if 14 days have passed from that date.

 

[adam087]

Sorry. I'm confused now. Dates in April would correctly turn red based on the above formula. Otherwise, what date are you comparing against?

/AJ

 

[sburkhar]

ok - let me give it a try.