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