planner

phil_green 

Thanks, you almost managed to cut off the essential information at the top <grin>.

 

Click in the cell where you want the first date.

Enter the following formula in the cell, then press Enter.

 

=SEQUENCE(1, 52, DATE(2023, 1, 7), 7)

 

The SEQUENCE function creates a series of evenly spaced values.

The first argument 1 tells Excel that you want the result in 1 row.

The second argument 52 specifies that you want 52 columns.

The third argument DATE(2023, 1, 7) provides the starting value: the date with year 2023, month 1 (January) and day 7.

The last argument 7 tells Excel that the values will increase with a step of 7 (days, i.e. a week).

 

Excel will automatically return the result in 52 cells next to each other in a row.

Select these 52 cells, then apply the date format of your choice from the Number Format drop down on the Home tab of the ribbon.