How can I change the day of the week to week.
Ex.
01/02/06 - week 1
02/10/06 - week 5
Thank you
Juran
How can I change the day of the week to week.
Ex.
01/02/06 - week 1
02/10/06 - week 5
Thank you
Juran
Have a look in the help index for WEEKNUM
--
Don Guillett
SalesAid Software
[email protected]
"Juran" <[email protected]> wrote in
message news:[email protected]...
>
> How can I change the day of the week to week.
> Ex.
>
> 01/02/06 - week 1
> 02/10/06 - week 5
>
> Thank you
>
> Juran
>
>
> --
> Juran
> ------------------------------------------------------------------------
> Juran's Profile:
> http://www.excelforum.com/member.php...o&userid=23592
> View this thread: http://www.excelforum.com/showthread...hreadid=544006
>
02/10/06 will not return week 5 regardless using ISO or absolute,
with 02/10/06 in A1
absolute weeknumber
=WEEKNUM(A1) returns 6
The non ATP version
=INT(((A1-DATE(YEAR(A1),1,0))+6)/7)
returns 6
ISO weeknumber
=1+INT(MIN(MOD(A1-DATE(YEAR(A1)+{-1;0;1},1,5)+WEEKDAY(DATE(YEAR(A1)+{-1;0;1},1,3)),734))/7)
returns 6
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"Juran" <[email protected]> wrote in
message news:[email protected]...
>
> How can I change the day of the week to week.
> Ex.
>
> 01/02/06 - week 1
> 02/10/06 - week 5
>
> Thank you
>
> Juran
>
>
> --
> Juran
> ------------------------------------------------------------------------
> Juran's Profile:
> http://www.excelforum.com/member.php...o&userid=23592
> View this thread: http://www.excelforum.com/showthread...hreadid=544006
>
See also
http://www.rondebruin.nl/weeknumber.htm
And
http://www.rondebruin.nl/isodate.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message news:[email protected]...
> 02/10/06 will not return week 5 regardless using ISO or absolute,
>
> with 02/10/06 in A1
>
> absolute weeknumber
>
> =WEEKNUM(A1) returns 6
>
> The non ATP version
>
>
> =INT(((A1-DATE(YEAR(A1),1,0))+6)/7)
>
> returns 6
>
>
> ISO weeknumber
>
> =1+INT(MIN(MOD(A1-DATE(YEAR(A1)+{-1;0;1},1,5)+WEEKDAY(DATE(YEAR(A1)+{-1;0;1},1,3)),734))/7)
>
> returns 6
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "Juran" <[email protected]> wrote in message
> news:[email protected]...
>>
>> How can I change the day of the week to week.
>> Ex.
>>
>> 01/02/06 - week 1
>> 02/10/06 - week 5
>>
>> Thank you
>>
>> Juran
>>
>>
>> --
>> Juran
>> ------------------------------------------------------------------------
>> Juran's Profile: http://www.excelforum.com/member.php...o&userid=23592
>> View this thread: http://www.excelforum.com/showthread...hreadid=544006
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks