Referencing a date value within text

[SummerStudent]

Hi everyone,

Quick question. I need to combine text with a date value in another cell. I've used the following formula:

="On Order ("&INDIRECT("R2")&")"

And I get "On Order (37485)"

How do I get the final text to read:

"On Order (August 17)"

Any help would be appreciated....thanks.

Dino

 

[AJ]

Hi,

Try this...

="On Order ("&TEXT(INDIRECT("R2"),"mmmm dd")&")"

Rgds
AJ

 

[SummerStudent]

AJ,

Works beautifully. Thanks!

Dino

 

[Aladin Akyurek]

On 2002-08-23 10:43, SummerStudent wrote:
AJ,

Works beautifully. Thanks!

Dino

I don't understand the need for INDIRECT. If R2 houses a date, then:

="On Order ("&TEXT(R2,"mmmm dd")&")"

should suffice.