WEEKNUM - every 10 week 6 digits
Results 1 to 3 of 3

Thread: WEEKNUM - every 10 week 6 digits
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default WEEKNUM - every 10 week 6 digits

    Hi,

    I did use weeknum on my calendar table and it was mostly correct, but also incorrect in some places. So I'll probably have to remake, but I still want to understand the issue.

    But the absolute strangest thing that has occured is that every 10 week (10, 20, 30, 40 and 50) is a 6 digit number and increment for each day during that week. Any reason this might happen?

    For example 136584 is monday on week 10, while 136585 is tuesday etc.

    week 7, 8, 9, 136584, 11

    Any explanation?

  2. #2
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,743
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: WEEKNUM - every 10 week 6 digits

    How do you come to the conclusion that 136584 equals Monday
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I’m not perfect yet. "Memories are forever"

  3. #3
    New Member
    Join Date
    Jan 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: WEEKNUM - every 10 week 6 digits

    Quote Originally Posted by My Aswer Is This View Post
    How do you come to the conclusion that 136584 equals Monday
    Well simple answer is I do have columns DATE/YEAR/MONTH/DAY/QUARTER/WEEK. On the week column I had 7 rows of each weeknum obviously. But as week 10 "starts" (always monday) instead of having "10" written out, i have a 6 digit number (and above was an example for.. week 10 in mars 2000?
    FORMAT ( [Date];WEEKNUM([Date];2)

    But as i said; that week 10 20 30 40 50 doesnt "exist" instead is replaced by some 6 digit value which is +1 for every day that week. But week 1-9 11-19 21-29 etc does show up normally.


    To note tho, I did scrap this column, just interested if anyone had any similar issue and explanation what may've been.

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
  •