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