cantosh's formula's use of TEXT is a good insight. If we apply that in my formula it gets much shorter. Note that cantosh's formula is specific to 2016 whereas my formula adapts to whatever is the current year. It is not clear what your needs are.

="CW "&COLUMN()&" ("&TEXT(DATE(YEAR(TODAY()),1,1)+(7-WEEKDAY(DATE(YEAR(TODAY()),1,1),12))+7*(COLUMN()-1),"mm.dd")&" - "&TEXT(DATE(YEAR(TODAY()),1,1)+(7-WEEKDAY(DATE(YEAR(TODAY()),1,1),12))+7*(COLUMN()-1)+4,"mm.dd")&")"