Date and Text combination

[Punit]

Hi,

could someone help me with getting this particular format in ONE SINGLE
cell:

Text 25-Sep

Please note that the date part has to be variable, i.e i shuld be able
to drag the last cell to create a new cell with the next date. The Text
is some constant text that has to be prefixed to the date in each cell.
So my row could look something like :

Week of 7-Oct Week of 14-Oct Week of 21-Oct Week of 28-Oct





thanx in advance!!

 

[Pete_UK]

Enter your first date into cell A1, then in B1 enter this formula:

=A1+7

Copy the formula from B1 into C11 (or however many columns you want
to use.

Then highlight the cells A1 to D1 (or whatever) and click Format |
Cells | Number (tab) and enter the following:

"Week of "dd-mmm

If you then want to use other columns, copy D1 across as required.

Hope this helps.

Pete

 

[Pete_UK]

Sorry, I should have said select Custom after Format | Cells | Number
(tab)

Pete

 

[Pete_UK]

You're welcome.

Pete

Thanx a lot, Pete!!