Date and Text combination

P

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!!
 
P

Pete_UK

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

=A1+7

Copy the formula from B1 into C1:D1 (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
 
Top