In Cell D3 I put =TODAY()
My Dates were in Cells D6:L6
I put the following Conditional Format into D6 then copied it to the others =IF(D$6>=($D$3+7),1,0)it seemed to work fine for me.
hwyl
Jonsi B-)
"We live in a society exquisitely dependent on science & technology, in which hardly anyone knows anything about science & technology"