View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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