| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Columns | Excel Discussion (Misc queries) | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| Sorting columns | Excel Worksheet Functions | |||
| sorting more than 3 columns | Excel Discussion (Misc queries) | |||
| Sorting 2 columns | Excel Discussion (Misc queries) | |||
Linear Mode
