WEEKNUM change start of week to a monday

T

The Rook

I am wanting to use the WEEKNUM formula, but I want the weeks to run Monday
to Sunday and not the standard Sunday to Monday-

How can I change this?
 
R

Ron de Bruin

Hi The Rook

There is a second argument

1) Excel WEEKNUM function (optional second argument of 1 (default)). Week 1
starts 1-Jan with subsequent weeks starting on a Sunday and final week ending on 31-Dec.

2) Excel WEEKNUM function (optional second argument of 2). Week 1 starts
1-Jan with subsequent weeks starting on a Monday and final week ending on 31-Dec.

If you want to use the ISO weekumber see
http://www.rondebruin.nl/weeknumber.htm
 

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

How to implement two shifts per day with multiple teams 0
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct" 3
Cross referencing a weekly menu list with a grocery list 1
Weeknum(today()) gives wrong weeknummer 6
CALENDAR CREATION 1
Please help with a date formula. 3
Shift Patterns 2
Custom Lists 0

Top