Sorting columns on weekdays

[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

 

[Luke M]

Use a helper column, with this formula copied down:

=WEEKDAY(A2,2)

This translate Monday = 1, Tuesday = 2, etc. Then sort by the helper column
first, then dates (to keep the Mondays in order)

 

[Michel]

tHello,

Thank you for your reply. Is it possible to achieve this without adding an
extra column? To sort the actuel column that contains the dates by means of a
function or programming aid?

Many thanks and greetings,

Michel