Try this
Change A1 to your needs
="Balance Sheet"&TEXT(A1," m/d/yyyy")

"Sarah74" wrote:

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".