-----Original Message-----
days thing -
have a column next to your dates, say in B1) that uses
=weekday(A1)
Then have a small table somewhere in your workbook that
lists the days as weekdays - this is how Excel stores them:
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
Name that table as, say, DAYS - as a named range. Then in
another column do =lookup(B2,days) This will give you
the correct day for the date. Just sort by this column
using Data - Sort and all your days will be together. You
can always HIDE the columns you don't want then.
Sall
.
