Hello,

I suggest to apply a conditional format:
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Look for: "Formula is: (within next 8 days)
=AND($B1TODAY(),$B1<TODAY()+8)"

Regards,
Bernd