+ Reply to Thread
Results 1 to 4 of 4

Week

  1. #1
    Registered User
    Join Date
    05-20-2005
    Posts
    22

    Week

    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

  2. #2
    Don Guillett
    Guest

    Re: Week

    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
    >




  3. #3
    Peo Sjoblom
    Guest

    Re: Week

    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
    >




  4. #4
    Ron de Bruin
    Guest

    Re: Week

    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
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1