Formula with text and reference to a date cell
 

Hi all,

I am wanting to the following in a cell:

Week ending 31 Dec

The "Week ending" will be text, but I want the date portion to read
from another cell containing the date so that I don't need to update
this cell each week. The source cell with the date in is formatted
dddd, dd mmm.

Is this possible? When I tried it, all I got was the date serial
number.

Thanks.

Rob

Hi

With A1 as source cell
="Week ending " & TEXT(A1,"d MMM")

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


wrote in message
oups.com...
Hi all,

I am wanting to the following in a cell:

Week ending 31 Dec

The "Week ending" will be text, but I want the date portion to read
from another cell containing the date so that I don't need to update
this cell each week. The source cell with the date in is formatted
dddd, dd mmm.

Is this possible? When I tried it, all I got was the date serial
number.

Thanks.

Rob