day of week without detail
 

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.

day of week without detail
 

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.

day of week without detail
 

This is a common problem. If you just use format "dddd", then sorting will
not bring all the "Friday"s together. If will sort in date order.


What you want is something like:

=TEXT(TODAY(),"dddd")
or
=TEXT(A1,"dddd") if A1 contains a date.
--
Gary's Student


"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.