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

1. ## 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. ## Re: WEEKNUM - every 10 week 6 digits

How do you come to the conclusion that 136584 equals Monday

3. ## Re: WEEKNUM - every 10 week 6 digits

Originally Posted by My Aswer Is This
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.