Ok here's a way with conditional formatting that doesn't need the extra column.
Select the column of dates and choose Format>Conditional formatting. Select formula is and enter
=ROUND((A1+3)/7,0)=ROUND(TODAY()/7,0)
This assumes your week begins on Sunday Change the +3 to +4 for Monday, or +2 for Saturday
This message was edited by lenze on 2002-11-01 16:21