Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Ned to Create a new Calclulated Column

  1. #1
    Board Regular
    Join Date
    Feb 2006
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Ned to Create a new Calclulated Column


    Ned to Create a new Calclulated Column
    Have a table with a field called "Arrived Date" it will have a date value similar to December 1, 201

    I am trying to create a calculated column that automatically tells me what week this is from.

    How do I create a calculated column that provides this.

    Thanks

  2. #2
    Board Regular
    Join Date
    Nov 2016
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ned to Create a new Calclulated Column

    =WEEKNUM([Arrived Date],x)
    x depends on which of the many week number conventions you are using. I think ISO is 21 but it's a while since I last used it.

    Peter

  3. #3
    Board Regular
    Join Date
    Feb 2006
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ned to Create a new Calclulated Column

    Thanks I used 1 for week begins on Sunday.

    My original mistake was forgetting the ,x part

    Appreciate the assistance.

  4. #4
    Board Regular
    Join Date
    Nov 2016
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ned to Create a new Calclulated Column

    No problem,
    Just don't forget that the start of the year is also important. It creates a problem for global companies like the one I work for where US (Microsoft default) week numbers are different from the rest of the world.
    Last edited by peter789; Dec 6th, 2018 at 02:47 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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