Problem with date conditional formatting

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 actua...