Formula to Get week Number starting on Wednesday 2

[drom]

Hi and thanks in advance!

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

 

[MrMisster]

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

=IF(WEEKNUM(A2,13)=53,1,WEEKNUM(A2,13))