Date and Text combination

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Punit - 26 Sep 2006 09:11 GMT

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

Reply to this Message

Pete_UK - 26 Sep 2006 09:26 GMT

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

> Hi,
>
[quoted text clipped - 11 lines]
>
> thanx in advance!!

Reply to this Message

Pete_UK - 26 Sep 2006 09:29 GMT

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

Pete

> Enter your first date into cell A1, then in B1 enter this formula:
>
[quoted text clipped - 29 lines]
> >
> > thanx in advance!!

Reply to this Message

Pete_UK - 27 Sep 2006 09:17 GMT

You're welcome.

Pete

Punit wrote:

> Thanx a lot, Pete!!

> Sorry, I should have said select Custom after Format | Cells | Number
> (tab)
[quoted text clipped - 34 lines]
> > >
> > > thanx in advance!!

Reply to this Message