Returning date format to text in additional column
Is there a way to return a date formatted column to an additional text column using formulas? I'm looking to create a report. It's not letting me use the "date" formatted field. That field needs to remain in date format, so was looking to add an additional column so it will automatically populate the date into text format in an additional column that can be hidden not to interfere with the sheet.
Thanks in advance.