Thread: Formula with 2 cell values, One value is a date

Hi,

I'm having a little trouble with this formula.

Code:

='Data Entry'!A113&TEXT('Data Entry'!D113,"mm/dd/yyyy")

Sheet2 I6 =
First cell is A113 on Sheet Data Entry = Terminated
Second Cell is a date D113 on Sheet Data Entry = 4/4/2009

The result i'm getting is this:
"='Data Entry'!A113&TEXT('Data Entry'!D113,"mm/dd/yyyy")"
What I'm looking for is
"Terminated 4/4/2009"

Thanks for the help, Mike