Use a helper column. If dates are in col. A, use:

=WEEKDAY(A2,3)

and fill down. Then sort ascending based on this new
column.

HTH
Jason
Atlanta, GA

-----Original Message-----
i am making a spreadsheet of a weekly schedule, so i
need to be able to sort
and order a column not by day AND date (wednesday,
January 8, 2010), but
simply by day of the week. in 'format cells,' there is
no such capacity, and
when i sort ascending, it gives me the days in
alphabetical order and not in
day of the week order. does anyone know how to get excel
to order a column
from monday to friday (or sunday to saturday)? thanks so
much,
--
Laura
.