# Formula to Get week Number starting on Wednesday 2

#### drom

##### Active Member

This question is different than the previous one (looks like the desired values were wrong withing the previous post)
• In my last question (SOLVED)
• Question
• Anyway I am gonna use this formula as well

Now I would like to get the Formula In C2 for the Following table
• In our company the week number goes from Wednesday to Tuesday

Check the Following table:
 Row/Col A B C 1 DATE Desired WeekNumber Formula? 2 2020-Dec-23 Wednesday 52 3 2020-Dec-24 Thursday 52 4 2020-Dec-25 Friday 52 5 2020-Dec-26 Saturday 52 6 2020-Dec-27 Sunday 52 7 2020-Dec-28 Monday 52 8 2020-Dec-29 Tuesday 52 9 2020-Dec-30 Wednesday 1 10 2020-Dec-31 Thursday 1 11 2021-Jan-01 Friday 1 12 2021-Jan-02 Saturday 1 13 2021-Jan-03 Sunday 1 14 2021-Jan-04 Monday 1 15 2021-Jan-05 Tuesday 1 16 2021-Jan-06 Wednesday 2 17 2021-Jan-07 Thursday 2

I would like to have a formula in C1 to get the Week number I put manually in Column B

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### MrMisster

##### New Member
This should do it, tested it on a sheet until April 2022 and it seems to align.

Excel Formula:
``=IF(WEEKNUM(A2,13)=53,1,WEEKNUM(A2,13))``

Replies
1
Views
412
Replies
5
Views
91
Replies
3
Views
260
Replies
3
Views
183
Replies
3
Views
34

1,141,714
Messages
5,708,015
Members
421,540
Latest member
quocbinh

### 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.

### Which adblocker are you using?

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

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