Conditional formatting for dates 6 months or less

[sdemian]

Hi!
Totally new to the forum and I've looked for answers to my question but can't find one that works for me...

I want to format cells that have dates that are 6 months or less, but when I put in this formula =EDATE($D2,6)<TODAY(),

I get an error from Excel saying "There's a problem with this formula" and I can't figure out why! Any help would be greatly appreciated!

 

[arthurbr]

Perhaps try

=$D2<EDATE(TODAY(),6)

 

[sdemian]

Thanks Arthur, it accepted the formula but it hasn't formatted any cells, which it should as there are dates less than 6 months away...

and sorry about the thread title, will do a better job next time!

 

[arthurbr]

and sorry about the thread title, will do a better job next time!

Soory, that had nothing to do with you, I'll have to remove that from my sig

Thanks Arthur, it accepted the formula but it hasn't formatted any cells

I tried it and it works for me. I don't see any dates in your example that fit ( dumb question : have you formatted the CF?)
Did you select the entire range (col D) before applying the CF ?

 

[Kerryx]

Tried original formula also and it threw up #value error but once i went and formatted the column to date it worked fine.

 

[arthurbr]

If you're satisfied you can mark as solution