Calc, condiitional formatting, flagging a date older than 6 months


I’ve recently discovered conditional formatting which is great and it has been serving me very well, it is very nifty to produce cell dynamic highlighting via styles.

I am however not being able how to figure out how to do custom date checks using a formula

Basically what I want to achieve is to have dates in a date column highlighted if they are older than 6 months.

Could somebody provide me with some insight on how to achieve this? Some example or tutorial?

So far I’ve been reading some docs on-line that mention formulas in the conditional formatting, and I have also seen some old posts about what functions to use TODAY() EOMONTH(), etc. however for the life of me can’t figure it out.

Any help will be appreciated, thanks in advance.

For Example your Dates are in the Range D1:D366 … so your Condition for this Cellrange should be:

Formula           EDATE(D1;6)<NOW() 
1 Like

@karolus Thank you so much, it works like a charm.