Format Date in Cell with Text

M

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?
 
G

Gary''s Student

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

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