Thread: how to change when week starts on excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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 With QuoteReply With Quote