like this to infinity
Most Helpful Girl
Most Helpful Guy
You should be able to drag them otherwise
="Week "& column (a1)+/-x where x is your offset if not starting from column 1.
If starting in column D it would be
="Week "&column (a1)-3.
You'duse d1 too buttress issues if you're hiding stuff or have breaks in data.1