Format Date in Cell with Text
 

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?

Format Date in Cell with Text
 

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

or if you like the European form use dd/mm/yyyy
--
Gary''s Student - gsnu200782


"Mike H." wrote:

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?