Populate cell with Tax year week number not actual week number.

[The Jackal]

I would like to return a different week number than is actual.
I need week 1 to be from 27th March 2023 to 2nd April 2023 and week 2 to be 03 April 2023 to 10th April 2023 and so on.

So below shows the current formular but i dont want 14 a want 1.

I hope that makes sense. Its our tax year in the UK that i need to show and not the actual week number.

WEEK	MONTH	DATE
=IF([@[Date Sold]]="","",WEEKNUM([@[Date Sold]],2))	4	01/04/2023
14	4	01/04/2023
14	4	01/04/2023
14	4	01/04/2023
14	4	01/04/2023

 

[James006]

Hi,
Could following help :

=WEEKNUM(C2)-12

 

[The Jackal]

Hi,
Could following help :

=WEEKNUM(C2)-12

I went down that route but it doesnt work on weeks 1 - 12

 

[James006]

Hi,
Adjustment :

=WEEKNUM(A1)-12+IF(YEAR(A1)=2024,52,0)