Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change when week starts on excel
How can i change when the week starts on excel?
|
#2
|
|||
|
|||
Answer: how to change when week starts on excel
Changing the Week Start Day in Excel
By default, Excel considers Sunday as the first day of the week. However, you can change this setting to start the week on any other day of the week as per your preference. Here are the steps to change the week start day in Excel:
That's it! Now, Excel will consider the day you selected as the first day of the week. For example, if you selected Monday as the first day of the week, then the week will start on Monday and end on Sunday.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change when week starts on excel
Hi,
With, for example, the function Weeknum() it starts by default on a Sunday but if you include the optional switch then it can start on a Monday =Weeknum(a1,1) the 1 can be omitted. week starts on Sunday =Weeknum(a1,2) Week starts on Monday Mike "Savio" wrote: How can i change when the week starts on excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WEEKNUM change start of week to a monday | Excel Discussion (Misc queries) | |||
update week to week in excel. | Excel Worksheet Functions | |||
update week to week in excel. | Excel Worksheet Functions | |||
How do I change from a 7 day week to a 5 day week in Excel? | Excel Discussion (Misc queries) | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) |