Conditional formatting issues 2.0

[Camel123]

Hi,

Please see screenshot:
https://imgur.com/WEnzwsS

I have so many issues with this condiational formatting, now I am facing this. Everything looks perfectly correct to me but the conditional formatting still colors the cell, why?

 

[Norie]

What value do you actually have in the cell?

 

[Camel123]

This one:
2019-06-01

 

[Special-K99]

Shouldnt this just be

$E$19 < TODAY()

???

 

[Norie]

The TEXT function returns a string, you can't properly compare a string value to a date value.

 

[Camel123]

I need to compare by year/month and not year/month/day

 

[Camel123]

Any suggestions? I've also tried:
=$E$19<(YEAR(TODAY())&MONTH(TODAY())) but does not work.

 

[AlanY]

try

=(YEAR($E$19)+MONTH($E$19))<(YEAR(TODAY())+MONTH(TODAY()))

 

[Fluff]

Maybe
=$E$19<=EOMONTH(TODAY(),-1)