Setting up a word and advancing number in the same cell?

[Lynn Bartling]

Across a spreadsheet I have the date (i.e 07/04/03) and in the next cell I
have "Week 32"...I can set the cells up for the dates but I wondered if
there was a way to put the word "Week" in the cells and then have it
automatically add the next number... Week 33....Week 34. I wanted both the
word "Week" and the number "32" in the same cell. I would only want to do
it if it was fairly simple. Thanks.
Lynn

 

[Max]

One way:

Assume "Week 32" is supposed to appear in column C (col #3)

Put in C1: ="Week "&COLUMN()+29
(The number "29" is used as 32=3+29. Adjust to suit to get the commencement
week #)

Copying across C1:F1 will give Week 32, Week 33, Week 34, Week 35

 

[Lynn Bartling]

Thank you so much. This worked.
Lynn

One way:

Assume "Week 32" is supposed to appear in column C (col #3)

Put in C1: ="Week "&COLUMN()+29
(The number "29" is used as 32=3+29. Adjust to suit to get the commencement
week #)

Copying across C1:F1 will give Week 32, Week 33, Week 34, Week 35

 

[Max]

you're welcome, Lynn!