Thank you so much! This worked great! Very easy. I appreciate you both
answering so quickly. This is a great resource.

"vezerid" wrote:

Use this small modification:
=IF(BG40,IF(TODAY()(BG4+7),"PAST
DUE",""),IF(BE40,IF(TODAY()(BE4+16),"PAST
DUE",IF(TODAY()(BE4+13),"CHECK PERMIT","")),""))

Note, In addition to supplying the third argument in the correct IF(),
I also changed your If-False to a blank cell instead of a space (i.e.
"" instead of " "). This way you can later check for blank values.

HTH
Kostis Vezerides