I get the results you're looking for with the following:

="CW " & COLUMN()+ 15 & " " & TEXT(DATE(2016,1,-3)+(COLUMN()+14)*7,"dd.mm") & " - " & TEXT(DATE(2016,1,1)+(COLUMN()+14)*7,"dd.mm")

Put the formula in A1 and fill right. If your data doesn't start in column one, you'll need to adjust the "COLUMN + X" portion of the formula to match. "COLUMN + 15" should equal your desired week number and "COLUMN + 14" should be one less.