Display "this week" column headers w/date & day of week?
Put this formula in A1:
=TODAY()-WEEKDAY(TODAY())+1
and apply a custom format to the cell of "mm/dd/yyy - dddd" (without
the quotes). Then in B1 enter the formula:
=A1+1
Or, put this formula...
=TODAY()-WEEKDAY(TODAY())+ROWS($1:1)
in A1 and just copy it down.
Rick
|