Forum Discussion
Solved
Change excel calender start day.
Hi, Can someone help me with my issue? I am using the excel template 'SHIFT WORK Calendar' and the weeks start with Sundays but I want to change it to Mondays. I am using MS Office Home and s...
See the attached version (zipped because the forum does not allow attaching a template directly).
I changed the definition of the defined names for each of the months, you can inspect them in Formulas > Name Manager. I was too lazy to rename those, so the names still refer to Sun instead of Mon.
And I used the Replace dialog to change the weekday abbreviations in the first row of each month.
HansVogelaar Many thanks for the explanation, I tried it myself but it's not working. I'm just using yours. Thanks again for your help.