day of week without detail

R

roadking

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

vezerid

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

=TEXT(Sheet1!A2,"dddd")

HTH
Kostis Vezerides
 
G

Gary''s Student

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