Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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

  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relative Chart Title? Nick M Charts and Charting in Excel 6 June 22nd 05 09:24 PM
How to get a cell reference of by searchig a text string? Najeeb Excel Discussion (Misc queries) 1 January 3rd 05 08:03 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"