Format Date in Cell with Text

[Mike H.]

I have a named range, DT, which contains a date value. I wish to display in
a cell:
="Revenue Account Summary As Of " & DT
But I get "Revenue Account Summary As Of 39566". How can I format the Dt in
the cell?

 

[Gary''s Student]

="Revenue Account Summary As Of " & TEXT(DT,"mm/dd/yyyy")

or if you like the European form use dd/mm/yyyy