Formula with text and reference to a date cell

  • Thread starter Thread starter robin_gould_durban
  • Start date Start date
R

robin_gould_durban

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goto specified date 3
Automatically update a cell with a date based on anther cells date 2
Dates and days of the week 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Extract the Month from a cell with a formatted date 3
Using VBA to change a cell format to date doesn't get "committed" 3
Formula help 1
Please help with a date formula. 3

Back
Top