Sorting columns on weekdays

  • Thread starter Thread starter Michel
  • Start date Start date
M

Michel

Hello,

I have a column with a range of subsequent dates. I want to sort them on
weekdays, so that all the mondays come first one after the other, then all
tuesdays, then all wednesdays and so on...

How can I achieve this?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel
 
You might try using a "helper" column. In an unused column, put the
following formula in the first cell with a date in your original column:

=WEEKDAY(A2,2)

The "2" in the formula ensures that Monday is the first day of the week.
Drag this formula down your helper column to cover all the cells that have a
date in your original column.

Then you can sort your data based on the integers in the helper column.

HTH,

Eric
 
You could use another column with a formula like:
=weekday(a1,2)

You'll see 1 thru 7.

1 is Monday ... 7 is Sunday

Then you can sort your data by this helper column.
 
You've got more replies at your other post, too.
Hello,

I have a column with a range of subsequent dates. I want to sort them on
weekdays, so that all the mondays come first one after the other, then all
tuesdays, then all wednesdays and so on...

How can I achieve this?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel
Click to expand...
 
Hello,

To all that did reply: many thanks.
I wondered if a solution was possible without adding an extra column. Can
you sort the actual colomn in which the dates are, by means of a function or
a programming aid, so that the actual column, that contains the dates is
sorted without adding another column?

Many thanks and greetings,

Michel
 
There may be a convuluted way, but I don't think that there's anything as
straightforward as the suggestion you have.
 
Back
Top