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.