Kujo,

In a cell of your choice, type in the date you want to test ....

Then Go to Menu Format Conditional Formatting
and play around with the sample formula to understand how it works ...

Only then you can move on and refine your formula according to your
needs ..

HTH
Carim