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
|