Sorting columns on weekdays
 

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

Sorting columns on weekdays
 

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Michel" wrote:

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

Sorting columns on weekdays
 

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