=WEEKNUM

G

Guest

I am using the WEEKNUM function in a worksheet, but excel seem to use Sunday
as the 1st day of the week. Our working week is Monday to Sunday,

Is there anyway of changing it so the Monday is the 1st day of the week?

TheRook
 
B

Bob Phillips

=WEEKNUM(A1,2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Fiscal Year Week Number Calculation with a twist.... 6
WeekNum Trouble 4
Excel conditional formatting with Weeknum 4
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct" 3
Filter a List 3
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October 4
Week number converted to date 6
WEEKNUM calculations for week stating with Tuesday 7

Top