Conditional formatting for date

[kaypump]

Can someone please help with this conditional format.
I will like colour of the cell (column M) to change if the SOS (column M) date is in 7 days and their is no scope column D.
Thank you very much for your anticipated support.

[JieJenn]

Highlight M6:M8, conditional formatting, custom rule, then enter

=AND(ABS($M6-NOW())<7,$D6="No")