how to change when week starts on excel

  • Thread starter Thread starter Savio
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defaulting to date format 4
Change default font color for a single spreadsheet? 10
Spam 4
Formula to return Vacation weeks 1
Custom 4 week periods 1
See Changes in Worksheet Submitted Weekly 1
NEW Excel Problem 2
Populate excel sheet based on values in a separate sheet 3

Back
Top