Thanks for your response, but the page you referred to provide me with any
new information; I would need to know how to launch msg.box when a date is
found on the sheet that is two days away.

Thanks for your continued help.

Danny

"Bernd" wrote:

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