How can i change when the week starts on excel?
M Mike H Feb 2, 2009 #2 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
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
