Sorting Data Within the Same Cell

[NAV]

Is there a way to sort data that's within data being
sorted?

For example, I'm using the ddd mm/dd/yyyy format to format
dates within cells. I'd like to sort the data based on
the ddd portion of the date format (i.e., all Monday's
together, all Tuesday's together, etc.).

There are 5,000+ rows in this worksheet, so it's not as
simple as manually inputting the day information next to
the corresponding cells.

Any help would be appreciated.

Thank you.
NAV

 

[Frank Kabel]

Hi
use a helper column with a formula like
=WEEKDAY(A1,2)
copy this formula for all rows and sort with this row

 

[Guest]

I see your busy today, Frank. ;-)

Anyway, this worked perfectly.

Thank you,
NAV