WEEKNUM - every 10 week 6 digits

ddlyturtle

New Member
Joined
Jan 11, 2019
Messages
3
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?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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.
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top