How to sort by day not date in Excel 2016

only with an additional column with WEEKDAY()

Originally Posted by tim201110

only with an additional column with WEEKDAY

No, Tim, there is absolutely no need for a helper column. Look (I have added the Monday markers manually just for demonstration purposes):

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	01/01/2017
2	02/01/2017	Monday		02/01/2017
3	03/01/2017			09/01/2017
4	04/01/2017			16/01/2017
5	05/01/2017
6	06/01/2017
7	07/01/2017
8	08/01/2017
9	09/01/2017	Monday
10	10/01/2017
11	11/01/2017
12	12/01/2017
13	13/01/2017
14	14/01/2017
15	15/01/2017
16	16/01/2017	Monday
17	17/01/2017
18	18/01/2017
19	19/01/2017
20	20/01/2017
21	21/01/2017

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	D
2	=IFERROR(INDEX(A:A,SMALL(IF(WEEKDAY($A$1:$A$21)=2,ROW($A$1:$A$21)),ROWS($A$1:A1))),"")

Sheet: Sheet1

confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Originally Posted by tim201110

seems we are are talking about the same thing

It seems we are NOT talking about the same thing! I understand that the OP wishes to extract this data. We shall have to wait until he tells us one way or the other.

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.