concatenate text and date formula

[banneduser123]

Hi, quick question -

In cell A1 I have text.
Cell A2 has a date, in date format.

I would like a formula that will concatenate the text and date and have it read properly (meaning with the date format.

E.g.:

A1: Trade Date
A2: 5/13/17

at the moment when I use either:
=A1&" "&A2
it produces:
Trade Date 42868

and the same when I try to concatenate

however, I need it to read as "Trade Date 5/13/17"

any help would be greatly appreciated.

thanks in advance

 

[kgartin]

=A1&" "&text(A2,"M/DD/YY")

 

[AliGW]

Try this:

=A1&" "&TEXT(A2,"m/d/yy")

 

[kgartin]

Yeah go with Ali's...mine would give you 5/01/17 instead of 5/1/17

 

[banneduser123]

perfect! thanks a lot Kgartin and AligW!

 

[AliGW]

You're welcome!