WEEKNUM Issue

Question

I track Items sold by week. for some reason the formula is not working. There is only 1 date in week 1. Week 2 starts on 1/2?

Answer 1

Thank you

Answer 2

did not follow...

01-jan-22 was a Saturday, 02-Jan-22 being a Sunday, Week#1 would end on 02-Jan-22 and Week#2 would start on Monday (03-Jan-22)

Unless you want your weeks to start on a day different than Monday, the result shared by you is as per above logic,

If you want your week to start on a some other day, you can select the 2nd parameter accordingly.

If the above is not what is needed, please explain what is the result you are expecting.

Answer 3

The first week of the year is the week that contains that year's first Thursday

(='First 4-day week'). ISO representation: 2022-W01

Answer 4

Thanks for the reply. It did not work. What day of the sale does not matter just what week. I tried changing to the 2 and the results changed to this. It appears to be happening in week 1 only. Any other week is fine.

12/27/21	53
12/28/21	53
12/29/21	53
12/30/21	53
12/31/21	53
1/1/22	1
1/2/22	1
1/3/22	2
1/4/22	2
1/5/22	2

Answer 5

the starting day of the week is determined by the second parameter of WEEKNUM

if we dont specify the second parameter, it takes 1 (assumes that weeks starts on Sunday)

i assume that you want the week to start on Monday.

Try putting 2 as the second parameter

eg WEEKNUM(A1, 2)

you can refer below link for details on the function https://support.microsoft.com/en-us/office/weeknum-function-e5c43a03-b4ab-426c-b411-b18c13c75340