Forum Discussion
planner
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.
Thanks. Select File > Account.
You'll see the version of Office on the right hand size. Please report it here.
regards phil
- Thank you very much for this. it would of took me ages to do that one at a time.
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.
Of what? Microsoft 365? Office 2021? Office 2019? ...