How can i change when the 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:

1. Open your Excel workbook and click on the "File" tab in the top left corner of the screen.
2. Click on "Options" from the left-hand menu.
3. In the Excel Options dialog box, click on "Calendar" from the left-hand menu.
4. Under the "First day of week" section, select the day of the week that you want to set as the first day of the week.
5. Click on "OK" to save the changes.

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.

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?