how to change when week starts on excel
How can i change when the week starts on excel?
|
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. |
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? |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com