Concatenate problem with date

[Jason789]

In B2 I have "Sat" for Saturday. In C2 I have "12/27" for 12/27/2003. I
D2 I want to have "Sat, 12/27." My formula in D2 is '=B2&", "&C2'...bu
the cell displays "Sat, 37982". Is there a simple way to show what
want in D2? Thank you.

Jaso

 

[Frank Kabel]

Hi Jason
one way:
=B2 & TEXT(C2,"MM/DD")

or why not use the formula
=C2
and use a custom format for this:
DDD, MM/DD

 

[Jason789]

Frank,

Both do what I want. Thanks so much for your help!

Jaso