Weeknumber back to 1 after 52

chally3

Board Regular
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
 

Some videos you may like

This Week's Hot Topics

Top