ISO New Year

Cell A1 is January 1 of the year to be calculated.

=IF(WEEKDAY(A1)>5,A1-(WEEKDAY(A1)-2)+7,A1-(WEEKDAY(A1)-2))

This is a shorter version.

=A1-(WEEKDAY(A1)-2)+(INT(WEEKDAY(A1)/6)*7)