Assuming TODAY() is the latest date i.e. no future dates:

Date in column A:

Highlight column A

FormulaIs: =A1=Today()-14

HTH

"JethroUK" wrote:

I am trying (unsuccessfully) to apply conditional formatting to a column of
dates

It needs to identify dates less than a fortnight old e.g.

Formula is <=TODAY()-14

but i just can't get it to work - any ideas