software

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: www.excelforum.com/member.php...oamp;userid=23592
View this thread: www.excelforum.com/showthread...hreadid=544006Have a look in the help index for WEEKNUM

--
Don Guillett
SalesAid Software

quot;Juranquot; gt; wrote in
message ...
gt;
gt; How can I change the day of the week to week.
gt; Ex.
gt;
gt; 01/02/06 - week 1
gt; 02/10/06 - week 5
gt;
gt; Thank you
gt;
gt; Juran
gt;
gt;
gt; --
gt; Juran
gt; ------------------------------------------------------------------------
gt; Juran's Profile:
gt; www.excelforum.com/member.php...oamp;userid=23592
gt; View this thread: www.excelforum.com/showthread...hreadid=544006
gt;
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 6ISO 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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Juranquot; gt; wrote in
message ...
gt;
gt; How can I change the day of the week to week.
gt; Ex.
gt;
gt; 01/02/06 - week 1
gt; 02/10/06 - week 5
gt;
gt; Thank you
gt;
gt; Juran
gt;
gt;
gt; --
gt; Juran
gt; ------------------------------------------------------------------------
gt; Juran's Profile:
gt; www.excelforum.com/member.php...oamp;userid=23592
gt; View this thread: www.excelforum.com/showthread...hreadid=544006
gt;
See also
www.rondebruin.nl/weeknumber.htm

And
www.rondebruin.nl/isodate.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;Peo Sjoblomquot; gt; wrote in message ...
gt; 02/10/06 will not return week 5 regardless using ISO or absolute,
gt;
gt; with 02/10/06 in A1
gt;
gt; absolute weeknumber
gt;
gt; =WEEKNUM(A1) returns 6
gt;
gt; The non ATP version
gt;
gt;
gt; =INT(((A1-DATE(YEAR(A1),1,0)) 6)/7)
gt;
gt; returns 6
gt;
gt;
gt; ISO weeknumber
gt;
gt; =1 INT(MIN(MOD(A1-DATE(YEAR(A1) {-1;0;1},1,5) WEEKDAY(DATE(YEAR(A1) {-1;0;1},1,3)),734))/7)
gt;
gt; returns 6
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Juranquot; gt; wrote in message
gt; ...
gt;gt;
gt;gt; How can I change the day of the week to week.
gt;gt; Ex.
gt;gt;
gt;gt; 01/02/06 - week 1
gt;gt; 02/10/06 - week 5
gt;gt;
gt;gt; Thank you
gt;gt;
gt;gt; Juran
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Juran
gt;gt; ------------------------------------------------------------------------
gt;gt; Juran's Profile: www.excelforum.com/member.php...oamp;userid=23592
gt;gt; View this thread: www.excelforum.com/showthread...hreadid=544006
gt;gt;
gt;
gt;