View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Copying groups of dates

Another way:

In A1 enter the last Friday of the old year.

in A3 enter: =A1+7
in A4 enter: =A3 and copy down to A11

Highlight A3 to A11 and copy to A13, A23 etc.

Don't quite catch the sense though because the information is always
the same except for the date. If you want to mark something you could
also do this:

In A2 enter the last Friday of the old year.
In A3 to A11 enter your text data
In B2 enter: =A2+7 and copy to the right as far as you want to go.

In the intersection of a text entry on the left and a date in row 2 you
can mark something.

Hans