In the new sheet use this formula, which looks at the original sheet,
assumed Sheet1:

=TEXT(Sheet1!A2,"dddd")

HTH
Kostis Vezerides

roadking wrote:
I want to convert the date to a day of the week, using the dddd format,
and copy to a new sheet. Every formating option I have tried also
brings over the date detail. I do not want this detail. I can not sort
because it sorts only on the detail.