Problem with date conditional formatting

[Marco97]

Hello everyone, im having trouble conditional formatting some dates in excel, as you can see in the screenshots, I inserted a IF function to check if the formula (between 30 and 15 days ago) is actually true, also the next one doesnt seem to work (less than 15 days ago).

Today is 29/01/2020.

Thanks to everyone for your help.

[#2]

@Marco97 

Much better if you attach sample file instead of screenshot. 

In your rules not formulas, just texts, e.g

(here AND is not closed)

[#3]

=SUMIF(P7:Z7;>=G11;P9:Z9) what is wrong here plz need to know

[#4]

@Sabry10 

That's answered here https://techcommunity.microsoft.com/t5/resources-and-community/modern-excel-webinars/m-p/1136794/hig...

[#5]

Here’s the sample file

[#6 · Accepted solution]

@Marco97 

I only corrected couple of misprints

Please check in attached file

[#7]

@Sergei Baklan Thanks a lot for your help!!

[#8]

@Marco97 , you are welcome

[#9]

=SUMIF(P7:Z7">="G11";P9:Z9)...sir i tried but not working