Outlook allows you to easily specify, but eExcel always treats Sunday as the first day of the week by default. Yes you can manipulate that within formulas and functions, but if you use the autofilter in excel and choose "this week" (or "next week", or "last week") excel considers Sunday as the first day of the week. I would like to know how (or if) this can be changed to Monday as the first day of the week.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do you set Monday as the first day of the week
- Thread starter schishol
- Start date
-
- Tags
- autofilter date weekday
cyrilbrd
Well-known Member
- Joined
- Feb 2, 2012
- Messages
- 4,113
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi, so no formula involved? But just changing the way excel sees Sunday not as the first day but as the seventh day of a week?
Thanks to clarify. Formula can be used to set any day as the first, but you may be referring to something different, right?
Thanks to clarify. Formula can be used to set any day as the first, but you may be referring to something different, right?
Upvote
0
With a formula you would get this result
[TABLE="width: 417"]
<tbody>[TR]
[TD]Date[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Mon-6-1[/TD]
[TD="align: right"]1[/TD]
[TD]=WEEKDAY(A2,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Tue-7-1[/TD]
[TD="align: right"]2[/TD]
[TD]=WEEKDAY(A3,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Wed-8-1[/TD]
[TD="align: right"]3[/TD]
[TD]=WEEKDAY(A4,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Thu-9-1[/TD]
[TD="align: right"]4[/TD]
[TD]=WEEKDAY(A5,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Fri-10-1[/TD]
[TD="align: right"]5[/TD]
[TD]=WEEKDAY(A6,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Sat-11-1[/TD]
[TD="align: right"]6[/TD]
[TD]=WEEKDAY(A7,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Sun-12-1[/TD]
[TD="align: right"]7[/TD]
[TD]=WEEKDAY(A8,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Mon-13-1[/TD]
[TD="align: right"]1[/TD]
[TD]=WEEKDAY(A9,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Tue-14-1[/TD]
[TD="align: right"]2[/TD]
[TD]=WEEKDAY(A10,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Wed-15-1[/TD]
[TD="align: right"]3[/TD]
[TD]=WEEKDAY(A11,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Thu-16-1[/TD]
[TD="align: right"]4[/TD]
[TD]=WEEKDAY(A12,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Fri-17-1[/TD]
[TD="align: right"]5[/TD]
[TD]=WEEKDAY(A13,2)[/TD]
[/TR]
[TR]
[TD="align: right"]Sat-18-1[/TD]
[TD="align: right"]6[/TD]
[TD]=WEEKDAY(A14,2)[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
Upvote
0
Correct. Has nothing to do with formulas or functions. Apply an autofilter to a table with some dates in it and you will see the options to filter it by week. This is what I am referring to.
Upvote
0
Similar threads
- Solved
