weeknum function says jan1=week1, mod to first 4 day week needed

using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is
week 1 when you're using the weeknum function. (in this year.only 1 day in
week1).. how does one modify this so that week 1 of the weeknum function is
the first 4 day week.. is there a mod i need to apply?

See

http://cpearson.com/excel/weeknum.htm

In article <13FA0A14-8BCC-4FF1-AAAD-ECCCAB9B6061@microsoft.com>,
sam <sam@discussions.microsoft.com> wrote:

> using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is
> week 1 when you're using the weeknum function. (in this year.only 1 day in
> week1).. how does one modify this so that week 1 of the weeknum function is
> the first 4 day week.. is there a mod i need to apply?

See Chip's site for an ISO weeknumber formula.
http://www.cpearson.com/excel/weeknum.htm

--
HTH

Bob Phillips

"sam" <sam@discussions.microsoft.com> wrote in message
news:13FA0A14-8BCC-4FF1-AAAD-ECCCAB9B6061@microsoft.com...
> using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1
is
> week 1 when you're using the weeknum function. (in this year.only 1 day
in
> week1).. how does one modify this so that week 1 of the weeknum function
is
> the first 4 day week.. is there a mod i need to apply?

Hi Sam

See also
http://www.rondebruin.nl/isodate.htm

And
http://www.rondebruin.nl/weeknumber.htm



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


"sam" <sam@discussions.microsoft.com> wrote in message news:13FA0A14-8BCC-4FF1-AAAD-ECCCAB9B6061@microsoft.com...
> using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is
> week 1 when you're using the weeknum function. (in this year.only 1 day in
> week1).. how does one modify this so that week 1 of the weeknum function is
> the first 4 day week.. is there a mod i need to apply?