Start the week from Monday instead of Sunday using the "this week" filter.

[sarao18592]

I've seen a few questions on here asking the similar question but I never saw an apt response.

I currently have a lot of data and i'm trying to filter the data for each week. Excel's default is that the week starts on Sunday but the company I'm working for needs the week to start on Monday and end on Sunday. Is there anyway to solve this? I'm open to adding a macro too if someone could help me with it.

 

[Peter_SSs]

As far as I know it is not possible to change the starting day for that AutoFilter option. Would a helper column like this be any use? I Have added column E ....

21 03 13.xlsm
	D	E
1	Date	Date-1
2	05-March-2021	04-March-2021
3	13-March-2021	12-March-2021
4	10-March-2021	09-March-2021
5	07-March-2021	06-March-2021
6	08-March-2021	07-March-2021
7	15-April-2021	14-April-2021
8	02-February-2021	01-February-2021
ThisWeek

Cell Formulas
Range	Formula
E2:E8	E2	=D2-1

.. and then you could use the ThisWeek AutoFilter option on column E.

21 03 13.xlsm
	D	E
1	Date	Date-1
3	13-March-2021	12-March-2021
4	10-March-2021	09-March-2021
6	08-March-2021	07-March-2021
ThisWeek

Cell Formulas
Range	Formula
E3:E4,E6	E3	=D3-1

 

[sarao18592]

Hi,
That could definitely be a possible easy solution. But I have 47000 rows currently which will increase over time. Hence adding the helper column might be an issue in the long run. But I will definitely use that as an easy solution.

 

[Peter_SSs]

Hope it works out for you. ?

 

[jasonb75]

You can't change the default week but you could use an advanced filter, although this might make it more difficult if there are other criteria to apply.

Book1
	A	B
1	Date	Date
2	>=44263	<=44269
3	Date
4	05-Mar-21
5	13-Mar-21
6	10-Mar-21
7	07-Mar-21
8	08-Mar-21
9	15-Apr-21
10	02-Feb-21
Sheet3

Cell Formulas
Range	Formula
A2	A2	=">="&(TODAY()-WEEKDAY(TODAY(),3))
B2	B2	="<="&((TODAY()-WEEKDAY(TODAY(),3))+6)