need to email when cell is blank and row header date is over 2 weeks old

[JAVATHEHOT]

windows 7-64, excel 2007

i have tried 3 or 4 different ways for the last 2 days, i get close but no luck, I need a fresh set of eyes.


Driver ___ 4/1/12 ___ 4/2/12___ 4/3/12___ 4/4/12
xxxxxxx ___blank _____ NV _____ blank ___ blank
xxxxxxx____blank ____ blank ____ blank ___ blank
xxxxxxx ___blank ____ blank ____ blank ____ blank
xxxxxxx __1-shipper __ blank ____ blank ____ blank


need to email (dont need to send the sheet or workbook) when cell is blank and row header date is over 2 weeks old.

wow, this has been a pain.