Yes, but the date will have to be based on some "anchor" like the column of the cell. Also you have to indicate what year you want.

I assumed that CW 1 is in column A, and the year is the current year, and CW 1 starts on the first Monday of the year.

It is a very long formula. This formula could be simplified with the use of named formulas. Let me know if you would like to develop that.

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