ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   WEEKNUM to start on another day (https://www.excelbanter.com/excel-worksheet-functions/104650-weeknum-start-another-day.html)

Mungie

WEEKNUM to start on another day
 

I want to use the WEEKNUM function, and understand that you can choose
for your week to start on a Sunday or Monday. But my week here at the
office begins on a Saturday.

How can I get this formula to work for me?


--
Mungie
------------------------------------------------------------------------
Mungie's Profile: http://www.excelforum.com/member.php...fo&userid=4166
View this thread: http://www.excelforum.com/showthread...hreadid=571012


Ron de Bruin

WEEKNUM to start on another day
 
Hi Mungie

We have enough problems with 4 weeknumber systems
http://www.rondebruin.nl/weeknumber.htm
Please not create another one


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mungie" wrote in message
...

I want to use the WEEKNUM function, and understand that you can choose
for your week to start on a Sunday or Monday. But my week here at the
office begins on a Saturday.

How can I get this formula to work for me?


--
Mungie
------------------------------------------------------------------------
Mungie's Profile: http://www.excelforum.com/member.php...fo&userid=4166
View this thread: http://www.excelforum.com/showthread...hreadid=571012





All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com