beautiful... thank you all for your help! this has been driving me crazy at
work for a long time! -L

"tjtjjtjt" wrote:

Another option:
If you format your dates as days-Custom number format dddd.
Then, you can Sort by Days in this way:
Data | Sort | Options
Change the first key sort order to the days of the week spelled out.

This will also work if you've type Monday, Tuesday, etc. instead of storing
dates.

tj

"Laura" wrote:

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