Weeknumber back to 1 after 52

[chally3]

Hi all, can anyone help with my query please.

On our SS Columns AH2 onward contain data in week numbers, but it does not stop at 52 & revert back to week 1 for the new year

Below is the formula in AH2, cell AH3 = AH2+1, cell AH4 = "AH3+1" and so on

=INT((TODAY()-WEEKDAY(TODAY(),2)-DATE(YEAR(TODAY()+4-WEEKDAY(TODAY(),2)),1,4))/7)+2


does anyone know how I can change this to default back to week 1 after 52?

Thank you

 

[JimM]

In AH3 try

=IF(AH2+1>52,1,AH2+1) and copy down

 

[chally3]

Thank you