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?

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>